level 2
update T_HistoryPrint set DelFlag=0 where Barcode in(
select Barcode from (
select pr.Barcode,count(*) ct from T_HistoryPrint pr GROUP BY pr.Barcode) t where t.ct=1
) and Barcode in
(select Barcode from T_RenYuanXinXi where Barcode is not null and Barcode!='') ;
2016年04月10日 02点04分
1
select Barcode from (
select pr.Barcode,count(*) ct from T_HistoryPrint pr GROUP BY pr.Barcode) t where t.ct=1
) and Barcode in
(select Barcode from T_RenYuanXinXi where Barcode is not null and Barcode!='') ;