SELECT SUM(payAmt) FROM pos_tranpay WHERE payWay = 'B' AND sellWay = 'A' AND RtnFlowNo IS NULL;SELECT SUM(payAmt) FROM pos_tranpay WHERE payWay = 'C' AND sellWay = 'A' AND RtnFlowNo IS NULL;SELECT SUM(payAmt) FROM pos_tranpay WHERE payWay = 'D' AND sellWay = 'A' AND RtnFlowNo IS NULL红色标记的字段根据x表的nameId字段来查询,也就是说现在x表的nameId只有b、c、d,增加了A那么上面代码就要有所变动,这种情况如何去处理。
SELECT SUM(payAmt) FROM pos_tranpay WHERE payWay = 'B' AND sellWay = 'A' AND RtnFlowNo IS NULL;SELECT SUM(payAmt) FROM pos_tranpay WHERE payWay = 'C' AND sellWay = 'A' AND RtnFlowNo IS NULL;SELECT SUM(payAmt) FROM pos_tranpay WHERE payWay = 'D' AND sellWay = 'A' AND RtnFlowNo IS NULL红色标记的字段根据x表的nameId字段来查询,也就是说现在x表的nameId只有b、c、d,增加了A那么上面代码就要有所变动,这种情况如何去处理。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货