select * from A where not exists(select 1 from B where relationFiled1=A.relationFiled1[and relationFiled2=A.relationFiled2...and relationFiledn=A.relationFiledn]
select * from A where not exists(select 1 from B where A.col1=B.col1 and A.col2=B.col2)
select * from A where 主键字段 not in(select 主键字段 from B)
select * from A where checksum(*) not in (select checksum(*) from B)
select * from table_a where id no in (select id from table_b )
select * from A where id not in (select id from b)
select * from A a where not exists(select top 1 * from B where 主键字段=a.主键字段)
where id no in (select id from table_b )
from A a
where not exists(select top 1 * from B where 主键字段=a.主键字段)