select * from po_order_b where not in(select * from (select vordercode
from po_order_b
group by cproductmanid
having count(*)>1 ) b group by b.vordercode)
============
(select * from (select vordercode
from po_order_b
group by cproductmanid
having count(*)>1 ) b group by b.vordercode)这里返回的是一列订单编号,我想查询数据库中不包含这些订单号的记录
from po_order_b
group by cproductmanid
having count(*)>1 ) b group by b.vordercode)
============
(select * from (select vordercode
from po_order_b
group by cproductmanid
having count(*)>1 ) b group by b.vordercode)这里返回的是一列订单编号,我想查询数据库中不包含这些订单号的记录
from po_order_b
group by cproductmanid
having count(*)>1 ) b group by b.vordercode)