[myalsailamy]

كود :

SELECT SUM(commonclmnName) as Result from (
SELECT sum([firstClmnName] ) as commonclmnName FROM [FirstTable]
UNION ALL
SELECT sum([sacondClmnName]) as commonclmnName  FROM [sacondTable]
) newTableName

بهذه الطريقه يتم جمع القيم