select a.car_time_id from car_time a where a.car_time_id not in (select b.car_time_id from settlement b)在oracle里还可以这样写,而且效率更高:
select a.car_time_id from car_time a minus select b.car_time_id from settlement b
select a.car_time_id from car_time a minus select b.car_time_id from settlement b
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货