试一试这样:
1.SELECT CODE,SUM(QUAN) AS QUAN FROM TABa GROUP BY CODE HAVING SUM(QUAN)<>02.SELECT AA.CODE,SUM(AA.QUAN) AS AQ,SUM(BB.QUAN) AS BQ
FROM TABa GROUP BY AA.CODE HAVING SUM(AA.QUAN)<>SUM(BB.QUAN)
INNER JOIN TABb ON AA.CODE=BB.CODE
1.SELECT CODE,SUM(QUAN) AS QUAN FROM TABa GROUP BY CODE HAVING SUM(QUAN)<>02.SELECT AA.CODE,SUM(AA.QUAN) AS AQ,SUM(BB.QUAN) AS BQ
FROM TABa GROUP BY AA.CODE HAVING SUM(AA.QUAN)<>SUM(BB.QUAN)
INNER JOIN TABb ON AA.CODE=BB.CODE
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货