怎么样选择表A中字段YpID与表B中字段YpID内容不相同的所有记录的所有字段？

[tzsimple]

怎么样选择表A中字段YpID与表B中字段YpID内容不相同的所有记录的所有字段？

[ysycrazy]

select * from 表A where YpID not in(select distinct YpID from 表B)

[lxf31]

Select * From 表A Where YpID Not In(Select YpID From 表B)

[Myyokel]

select * from a where YpID not in(select YpID from b)

[sdhdy]

select * from 表A where YpID not in(select distinct YpID from 表B)

[happydreamer]

select * from A where not exists(select 1 from B where A.YpID=B.YpID)