22,209
社区成员
发帖
与我相关
我的任务
分享
select a.porder,a.eda,a.code, a.kvol,a.tjitu,b.kvol as bkvol,b.tjitu as btjitu from testsks.dbo.xslip as a
left join testtpics31.dbo.xslip as b
on a.porder=b.porder
and a.eda=b.eda
and a.code=b.code
and a.vendor=b.vendor
and a.kvol<>a.tjitu
and a.tjitu<>b.tjitu
进行筛选查询,得到的结果是a表的所有数据
left join
-->
inner join