模拟表结构
CREATE TABLE a (aid VARCHAR2(5), acou NUMBER(5, 2));
CREATE TABLE b (aid VARCHAR2(5), bcou NUMBER(5, 2));
模拟数据
INSERT INTO a (aid, acou) VALUES ('1', 50.0);
INSERT INTO b (aid, bcou) VALUES ('1', 30.0);
INSERT INTO b (aid, bcou) VALUES ('1', 40.0);
查询语句
SELECT ' ', SUM(acou) acou, SUM(bcou) bcou FROM a, b WHERE a.aid = b.aid;
错误结果集
' ', 100, 70
如何编写SQL语句正确分别统计两表的和,正确结果集应为
' ',50, 70