Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Merge result of two queries?
I need to 'fill in the gaps' in the results of SQL1 - notice that it
doesn't
return any results for 06/01/2006.
SQL2 returns results for all dates, with a forced count of 0.
How do I construct a query that would pad gaps in SQL1's results with the
results from SQL2?
Producing results of:
08/01/2006 20 07/01/2006 33 06/01/2006 0 05/01/2006 22 04/01/2006 19
Thanks in advance,
Edward
SQL1:
select date, count from table;
Results:
08/01/2006 20 07/01/2006 33 05/01/2006 22 04/01/2006 19
SQL2:
select date, 0 as count from dateTable;
Results:
08/01/2006 0 07/01/2006 0 06/01/2006 0 05/01/2006 0 04/01/2006 0 ----------------------------------------I am using the free version of SPAMfighter for private users. It has removed 452 spam emails to date.