SELECT A.ANAME,(SELECT SUM(BAMOUNT) FROM B WHERE B.AID=A.AID) FROM A
select ANAME,Bamount=ISNULL(SUM(Bamount),0) from a join b on a.aid=b.aid group by aname
select a.Aname,sum(b.Bamount) from a,b where a. Aid=b. Aid group by a.Aname
select a.Aname,isnull(sum(b.Bamount),0) from a,b where a. Aid=b. Aid group by a.Aname
SELECT A.ANAME,ISNULL(SUM(B.Bamount),0) AS Bamount FROM A LEFT JOIN B ON A.AID=B.AIDGROUP BY A.ANAME
select ANAME,Bamount=ISNULL(SUM(Bamount),0) from a left join b on a.aid=b.aid group by aname
select Aname,sum(isnull(Bamount, 0)) from A left join B on A.Aid=B.Aid group by Aname
你好,sql如下: select Aname,sum(isnull(Bamount, 0)) from A left join B on A.Aid=B.Aid group by Aname
DECLARE @Taba TABLE (Aid INT, Aname VARCHAR(20)) INSERT INTO @Taba SELECT 1 , 'aa' UNION ALL SELECT 2 , 'bb' UNION ALL SELECT 3 , 'cc' DECLARE @Tabb TABLE (Bid INT, Aid INT, Bamount INT) INSERT INTO @Tabb SELECT 1 , 1 , 5 UNION ALL SELECT 2 , 1 , 6 UNION ALL SELECT 3 , 1 , 8 UNION ALL SELECT 4 , 2 , 6 UNION ALL SELECT 5 , 2 , 7SELECT A.Aname,SUM(ISNULL(B.Bamount,0)) FROM @Taba A LEFT JOIN @Tabb B ON A.aid = B.Aid GROUP BY A.Aname/* Aname SumAmount -------------------- ----------- aa 19 bb 13 cc 0(3 行受影响) */
from a join b on a.aid=b.aid
group by aname
a.Aname,sum(b.Bamount)
from
a,b
where
a. Aid=b. Aid
group by
a.Aname
select
a.Aname,isnull(sum(b.Bamount),0)
from
a,b
where
a. Aid=b. Aid
group by
a.Aname
A.ANAME,ISNULL(SUM(B.Bamount),0) AS Bamount
FROM
A LEFT JOIN B ON A.AID=B.AIDGROUP BY A.ANAME
from a left join b on a.aid=b.aid group by aname
from A left join B
on A.Aid=B.Aid
group by Aname
select Aname,sum(isnull(Bamount, 0))
from A left join B on A.Aid=B.Aid group by Aname
INSERT INTO @Taba
SELECT 1 , 'aa' UNION ALL
SELECT 2 , 'bb' UNION ALL
SELECT 3 , 'cc' DECLARE @Tabb TABLE (Bid INT, Aid INT, Bamount INT)
INSERT INTO @Tabb
SELECT 1 , 1 , 5 UNION ALL
SELECT 2 , 1 , 6 UNION ALL
SELECT 3 , 1 , 8 UNION ALL
SELECT 4 , 2 , 6 UNION ALL
SELECT 5 , 2 , 7SELECT A.Aname,SUM(ISNULL(B.Bamount,0))
FROM @Taba A LEFT JOIN @Tabb B
ON A.aid = B.Aid
GROUP BY A.Aname/*
Aname SumAmount
-------------------- -----------
aa 19
bb 13
cc 0(3 行受影响)
*/