求sql语句:表a,表b结构相同,如何从a将在a中而不在b中的记录插入b中?(a-b的差插入b)

[ciml]

如题

[davytao1018]

insert into b select * from a where not in(select * from b)

[ciml]

not in不对,因为有多个字段
skyinfo(MFC) 是对的
结帐

[skyinfo]

INSERT INTO b (SELECT * FROM b T1 WHERE NOT EXISTS (SELECT * FROM a WHERE id=T1.id))

[skyinfo]

INSERT INTO b (SELECT * FROM a T1 WHERE NOT EXISTS (SELECT * FROM b WHERE id=T1.id))

[mschen]

insert b
select * from a
where not exists(select 1 from b where id=a.id)

[paoluo]

a-b的差插入b？？？
a、b不是表吗？？