B BLUE_SKY Unregistered / Unconfirmed GUEST, unregistred user! 2002-06-17 #1 [red]有两个表A,B,A中包含了B中的所有记录，现在要用SQL语句将这些记录删去，将结果保存到表C中，怎么写？[/red]
W westboy2000 Unregistered / Unconfirmed GUEST, unregistred user! 2002-06-17 #2 insert into C select A.* from A where A.关键字 not in (select B.关键字 from B);
B book523 Unregistered / Unconfirmed GUEST, unregistred user! 2002-06-17 #3 表中有没有关键值？假如有关键值id insert into c select * from a where id not in (select id from b)
P pcc_mmz1 Unregistered / Unconfirmed GUEST, unregistred user! 2002-06-27 #6 delete from a where a.key in (select id from b) insert into c select * from a
