表A(Test1)
表B(Test2)
sql 语句:
select a.Id,a.Name from Test1 a where not exists
(select b.Id from Test2 b where a.Id=b.Id)
查询结果为:
表A(Test1)
表B(Test2)
sql 语句:
select a.Id,a.Name from Test1 a where not exists
(select b.Id from Test2 b where a.Id=b.Id)
查询结果为: