select B.Line,Sum(Qty ) from A,B,C
where A.UID_A=B.UID_A and  C.SONo=A.SONo and B.Line=C.Line
group by B.Line

------解决方案--------------------
SQL code

Select B.Line,A.Qty,Sum(A.Qty) from A,B,C 
where A.UID_A=B.UID_A and C.SONo=A.SONo and B.Line=C.Line 
group by B.Line

------解决方案--------------------
探讨

SQL code
Select B.Line,A.Qty,Sum(A.Qty) from A,B,C 
where A.UID_A=B.UID_A and C.SONo=A.SONo and B.Line=C.Line 
group by B.Line


------解决方案--------------------
探讨

SQL code
Select B.Line,A.Qty,Sum(A.Qty) from A,B,C 
where A.UID_A=B.UID_A and C.SONo=A.SONo and B.Line=C.Line 
group by B.Line