问题描述:
SELECT CASE ABC.A WHEN'否' THEN'1' WHEN'是' THEN'-1' END AS 出入标识,ABC.B AS 数量,这两个字段相乘?
SELECT CASE ABC.A WHEN'否' THEN'1' WHEN'是' THEN'-1' END AS 出入标识,ABC.B AS 数量,我想让这个两个相乘,即出入标识*数量,我这样做的(CASE ABC.A WHEN'否' THEN'1' WHEN'是' THEN'-1' END*ABC.B) AS 新数量,这样做语句是错误的,不知如何能让这两列相乘?
SELECT CASE ABC.A WHEN'否' THEN'1' WHEN'是' THEN'-1' END AS 出入标识,ABC.B AS 数量,我想让这个两个相乘,即出入标识*数量,我这样做的(CASE ABC.A WHEN'否' THEN'1' WHEN'是' THEN'-1' END*ABC.B) AS 新数量,这样做语句是错误的,不知如何能让这两列相乘?
问题解答:
我来补答展开全文阅读