22,206
社区成员
发帖
与我相关
我的任务
分享
select * from 表A
where not exists(select 1 from 表B
where 箱号=表A.箱号 and 客户编号=表A.客户编号 and 体积<>a.长度*a.宽度*a.高度)
select * from 表A where not exists(select 1 from 表B where 箱号=表A.箱号 and 客户编号=表A.客户编号)
select * from 表A where not exists(select 1 from 表B where 箱号=a.箱号 and 客户编号=a.客户编号)
select * from b where not exists(select 1 from a where 箱号=b.箱号 and 客户编号=a.客户编号)
select * from b where not exists(select 1 from a where 箱号b.箱号 and 客户编号=a.客户编号)