delete Car_Time
where rowid<>
select max(rowid)
from Car_Time
where Car_Time.Car_time_ID =(
"Select Car_Time.Car_time_ID
from Car_Time
where Car_Time.Car_time_id not
in(select settlement.car_time_id from settlement)
order by car_time.Car_time_ID"))
利用他们的ROWID是唯一的。这样可以保留多条中的要和条
where rowid<>
select max(rowid)
from Car_Time
where Car_Time.Car_time_ID =(
"Select Car_Time.Car_time_ID
from Car_Time
where Car_Time.Car_time_id not
in(select settlement.car_time_id from settlement)
order by car_time.Car_time_ID"))
利用他们的ROWID是唯一的。这样可以保留多条中的要和条
delete ...
insert ... select * from ...