Hiya guys,
I have this SQL statement :

SELECT table1.DATA_CLERK;
FROM table1;
HAVING table1.date1 <= m.date1;
AND table1.date2 >= m.date2;
UNION ALL;
SELECT table2.data_clerk;
FROM table2;
HAVING table2.date1 <= m.date1;
AND table2.date2 >= m.date2;
into cursor Temp;

I want to use the results of the cursor Temp in a report. My problem is ..... how do I know which values are from table1 and which are from table2. I want the report to look something like:

Data_clerk records from table1 records from table2 total

wwwwww X Y X+Y
qqqqqq W W W+W
etc etc

Thanks in advance.



Richard.