SQL中如何將兩個(gè)查詢結(jié)果相加？SELECT ss1-ss2 FROM (SELECT SUM(s_money) AS ss1 FROM `shouqian`)s1，(SELECT SUM(f_mon
SQL中如何將兩個(gè)查詢結(jié)果相加？
SELECT ss1-ss2 FROM (SELECT SUM(s_money) AS ss1 FROM `shouqian`)s1，(SELECT SUM(f_money) AS ss2 FROM `faqian`)s2 就是兩個(gè)查詢語句查詢相加減的兩個(gè)表sum字段as命名 兩個(gè)表查詢命名 最后把這兩個(gè)查詢作為查詢表去用sum的ss1-ss2 就可以了
