select * from databasename1..A inner join databasename2..B on databasename1..A.a=databasename2..B.a and databasename1..A.b=databasename2..B.b and databasename1..A.c=databasename2..B.c where databasename1..A.d>=6试试
select * from databasename1..A inner join databasename2..B on databasename1..A.a=databasename2..B.a and databasename1..A.b=databasename2..B.b and databasename1..A.c=databasename2..B.c where databasename1..A.a=1 and databasename1..A.b=2 and databasename1..A.c=3 and (databasename1..A.d=7 or databasename1..A.d=8)
and (a.d=7 or b.d=8)这样行不?
lsxaa(小李铅笔刀) 的方法可以,得到的是集合运算中的 A - B select A.* from A left join B on A.a=b.a and a.b=b.b and a.c=b.c and a.d=b.d where b.a is null
楼主的数据关键是两个表的内容不同步,A里有的B里没有,是吧?(B 一定是A的子集合?) 不是具体数据是否大于6,或者等于7,8的问题。支持 select a.* from A left join B on A.a=b.a and a.b=b.b and a.c=b.c and a.d=b.d where b.a is null
inner join databasename2..B
on databasename1..A.a=databasename2..B.a and
databasename1..A.b=databasename2..B.b and
databasename1..A.c=databasename2..B.c
where databasename1..A.a=1 and databasename1..A.b=2 and
databasename1..A.c=3 and (databasename1..A.d=7 or
databasename1..A.d=8)
select A.*
from A left join B on A.a=b.a and a.b=b.b and a.c=b.c and a.d=b.d
where b.a is null
楼主的数据关键是两个表的内容不同步,A里有的B里没有,是吧?(B 一定是A的子集合?)
不是具体数据是否大于6,或者等于7,8的问题。支持
select a.*
from A left join B on A.a=b.a and a.b=b.b and a.c=b.c and a.d=b.d
where b.a is null
lsxaa(小李铅笔刀) 方法可用!
在此感謝大家