select * ----在table1但不在table2中
from (select distinct yy,mm, Org_id,bus_id from Monthorgsell) as t1
where not exists(
select distinct yy,mm, Org_id,bus_id
from MonthorgPlan as t2
where t1.yy=t2.yy and t1.mm=t2.mm and t1.org_id=t2.org_id and t1.bus_id =t2.bus_id
)
from (select distinct yy,mm, Org_id,bus_id from Monthorgsell) as t1
where not exists(
select distinct yy,mm, Org_id,bus_id
from MonthorgPlan as t2
where t1.yy=t2.yy and t1.mm=t2.mm and t1.org_id=t2.org_id and t1.bus_id =t2.bus_id
)
2360
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
