Firebird - Sum of total fields from different tables ?

[Henry Olive 5]

I wish everyone a healthy day.
Is there a way get sum of total fields from different tables ?

Something like below

(SELECT SUM(TOTAL) FROM TABLE1) + (SELECT SUM(TOTAL) FROM TABLE2) + (SELECT SUM(TOTAL) FROM TABLE3)

For Example 3 Field's Total Sum RESULT = 12,000.-

Thank You
 

 

[Vandrovnik 214]

SELECT
(SELECT SUM(a.Total) FROM Table1 a) +
(SELECT SUM(a.Total) FROM Table2 a) +
(SELECT SUM(a.Total) FROM Table3 a) as GrandTotal
FROM RDB$Database

 

[Henry Olive 5]

Perfect,  Thank You SO MUCH Vandrovnik