帮忙看个SQL 排除查询
表A
ProID ProName UserType UserID
-----------------------------
1 '产品A' 1 0
1 '产品A' 3 0
1 '产品A' 5 0
表B
ProID ProName UserType UserID
-----------------------------
1 '产品A' 1 0
1 '产品A' 3 0
1 '产品A' 5 0
1 '产品A' 0 27
1 '产品A' 0 33
要找出在表B中排除表A的数据.比较的字段是 ProID相同,UserType 和 UserID 同时不同
结果是
ProID ProName UserType UserID
-----------------------------
1 '产品A' 0 27
1 '产品A' 0 33
select * from 表B as B where ProID=1
and not exists
(
select 1 from 表A where ProID=B.ProID and UserType=B.UserTye and UserID=B.UserID
)
select b.* from 表B as B,表A as A where B.ProID=1
and A.ProID=B.ProID and UserType<>B.UserTye and UserID<>B.UserID
)
