24-03-2013, 04:47 PM
السلام عليكم
بإستخدام union
بالتوفيق
بإستخدام union
كود :
SELECT tabSum.StdName, sum(tabSum.Marks) as sumMarks
from
(
SELECT StdName, Marks from table1
union
SELECT StdName, Marks from table2
union
SELECT StdName, Marks from table3
) as tabSum
group by tabSum.StdName
