select Inspector1,CHICUN1,CHICUN2,CHICUN3,CHICUN4,CHICUN5,CHICUN6,CHICUN7,CHICUN8,CHICUN9,CHICUN10,CHICUN11,CHICUN12,CHICUN13,CHICUN14,CHICUN15,PO,ITEM,批次,日期,供应商,图号,订单数量 from dbo.Table1 where
select Inspector1,CHICUN1,CHICUN2,CHICUN3,CHICUN4,CHICUN5,CHICUN6,CHICUN7,CHICUN8,CHICUN9,CHICUN10,CHICUN11,CHICUN12,CHICUN13,CHICUN14,CHICUN15,PO,ITEM,批次,日期,供应商,图号,订单数量 from dbo.Table1 where isnull(CHICUN1,'')<>'' and isnull(Inspector1,'')<>''
select Inspector1,CHICUN1,CHICUN2,CHICUN3,CHICUN4,CHICUN5,CHICUN6,CHICUN7,CHICUN8,CHICUN9,CHICUN10,CHICUN11,CHICUN12,CHICUN13,CHICUN14,CHICUN15,PO,ITEM,批次,日期,供应商,图号,订单数量 from dbo.Table1 where CHICUN1 is not null and Inspector1 is not null