[求助]查询语句中子查询中用LIKE时这个%号如何写? Post By:2020/7/24 10:16:00 [显示全部帖子]
ppdj = ",ISNULL((S elect Sum(结算不含税金额) From {业务结算} b where a.批号 = b.批号 And a.合同关联编号 Like %b.合同关联编号% And b.属性 = '对外' And b.类型 = '采购' And b.审核 = 1) / (S elect Sum(结算数量) From {业务结算} b where a.批号 = b.批号 And a.合同关联编号 Like %b.合同关联编号% And b.属性 = '对外' And b.类型 = '采购' And b.审核 = 1),0) As 对外采购不含税单价"