sum across tables?????

rbuser

is it possible to sum across two tables?

i have the following two statements

select sum(current_Amount) as "Sum1" from md_AR_Pending;

select sum(current_Amount) as "Sum1" from tr_AR_Pending;




is it possible to combine them?


I want to use reportbuilder to show the total of the
currentAmount field from the two tables (md_AR_Pending, tr_AR_Pending);


I want to do this with counts as well

select count (*) as "Count1" from md_Ar_Pending;
select count (*) as "Count2" from tr_Ar_Pending


thanks

shane

nicocizik

Hi Shane,

The easiest way to go about this would be to handle all your calculations in
SQL code. You could perhaps join the two tables and select the sums as a
single dataset so RB can access them from the same datapipeline.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com