General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Another SQL Statement Question
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only