|| ' was paid on' || :new.paydate);测试它:set status=2car_ticket表:cid int, --- the car that violated parkingregulations
lid int, --- lot where violation took
Table1和Table2id tid2 200Table2100 A我想从Table1拿出任何Table2中不存在的tid的id。请帮助我如何写一个这样的查询,这样的方式,它将减少时间。select id from Table1 where tid not in (select tid from Table2)
select a.id from Table1 a inner joinTable2 b o