>Report
>Total Table1       Total Table2        Total Table3
>3000                7000               13000
>
>
>Thank you

John,

<PRE>
SELECT ;
		SUM(Amount1) AS Amount1, Sum(0) AS Amount2, SUM(0) AS Amount3;
	FROM Table1 ;	
UNION SELECT ;
		SUM(0) AS Amount1, Sum(Amount2) AS Amount2, SUM(0) AS Amount3;
	FROM Table2 ;	
UNION SELECT ;
		SUM(0) AS Amount1, Sum(0) AS Amount2, SUM(Amount3) AS Amount3;
	FROM Table3 ;
INTO CURSOR Amounts	

SELECT ;
		SUM(Amount1) AS Amount, Sum(Amount2) AS Amount2, SUM(Amount3) AS Amount3;
	FROM Amounts ;
	INTO CURSOR Summary