create a view v1 as select max(rowid) /*Or some other column you can identifi 2 rows*/, key from table2 where table2.key in (select table1.key from table1) group by keydelete from v1 Ofcourse , you need to customize your SQL according to your own table structure .
想最好能直接写个SQL删除啊。
as select max(rowid) /*Or some other column you can identifi 2 rows*/, key
from table2
where table2.key in (select table1.key from table1)
group by keydelete from v1 Ofcourse , you need to customize your SQL according to your own table structure .