select c.ITEM from (select * from dbo.活动区间ITEM a where convert(varchar(10), time, 120) >= '${p3}' and convert(varchar(10), time, 120) <= '${p4}' and a.ITEM not in (select ITEM from dbo.活动区间ITEM where convert(varchar(10), time, 120) >= '${p1}' and convert(varchar(10), time, 120) <= '${p2}'${if(p5="全部","",if(p5="其他","and left(ITEM,2) NOT IN ('AA' ,'AB', 'AC' ,'AD','AE')","and left(ITEM,2)='"+p5+"'"))})${if(p5="全部","",if(p5="其他","and left(ITEM,2) NOT IN ('AA' ,'AB', 'AC' ,'AD','AE')","and left(ITEM,2)='"+p5+"'"))} ${if(SQE="全部","","and SQE ='"+SQE+"'")}) c group by c.ITEM 我数据库里面还有供应商和SQE和TIME三列 我怎么同时查出来 |
1min目标场景问卷
立即参与
