SELECT dbo.B.B_ID, dbo.A.A_Name, SUM(dbo.B.B_Number1) AS B_Number1_Sum,
SUM(dbo.B.B_Nmuber2) AS B_Nmuber2_Sum, COUNT(*) AS Cnt
FROM dbo.A INNER JOIN
dbo.B ON dbo.A.A_ID = dbo.B.B_ID
GROUP BY dbo.B.B_ID, dbo.A.A_Name
SUM(dbo.B.B_Nmuber2) AS B_Nmuber2_Sum, COUNT(*) AS Cnt
FROM dbo.A INNER JOIN
dbo.B ON dbo.A.A_ID = dbo.B.B_ID
GROUP BY dbo.B.B_ID, dbo.A.A_Name
A.A_Name,
SUM(B.B_Number1) AS B_Number1_Sum,
SUM(B.B_Nmuber2) AS B_Nmuber2_Sum,
COUNT(*) AS Cnt
FROM A
INNER JOIN B ON A.A_ID = B.B_ID
GROUP BY B.B_ID, A.A_Name
from A t,B
where t.A_ID=B_ID
group by B_ID,t.A_Name
A.A_Name,
SUM(B.B_Number1) AS [Sum(B_Number1)],
SUM(B.B_Nmuber2) AS [Sum(B_Nmuber2)],
COUNT(*) AS [Count(*)]
FROM A
INNER JOIN B ON A.A_ID = B.B_ID
GROUP BY B.B_ID, A.A_Name
from A,B
where A_ID=B_ID
group by B_ID,A_Name
a_name as NAME,
sum(b_num1) AS [SUM(Number1)],
sum(b_num2) AS [SUM(Number2)],
count(*) AS [COUNT(*)]
from A,B
where A.a_id = B.b_id
group by b_id,a_name