|
if you are counting the rows it would look something like:
select a.record_1, b.record_2, etc
from
(select sum(column1) as record_1
from table XXX.XXX
where date >= 01/01/05) a,
(select sum(column2) as record_2
from table XXX.XXX
where date >= 01/01/05) b,
etc
This will give you one SQL output with all the fields totaled
|