(如何查询两表中不同字段sum之和)
话不多说,上Sql:SELECT SUM(money) FROM(SELECT SUM(T1.CONSUME_AMOUNT) AS money FROM WH_PRE_DEPOSIT_CONSUME T1 WHERE T1.STATE != ‘X’ AND T1.SHOP_ID =131 UNION
SELECT SUM(T2.PRE_DEPOSIT) AS money FROM WH_CUSTOMER T2 WHERE T2.STATE != ‘X’ AND T2.SHOP_ID =131) AS t
如有不懂之处,请联系我