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.
Paying users do not have this message in their emails.
Try www.SPAMfighter.com for free now!


.

Relevant Pages

  • SQL 2000 transactional replication is generating snapshot every hour
    ... SQL2 subcribed to SQL1, and publisher+distributor for SQL3 ... and at the same time SQL2 is generating a snapshot for every publication it ... 2GB) every hour for every publication. ...
    (microsoft.public.sqlserver.replication)
  • Windows security
    ... I want to back up a database from SQL1 and restore it ... I want mydbowner to have db_owner rights on mydbase on both ... course the login doesn't exist on SQL2. ...
    (microsoft.public.sqlserver.security)
  • RE: Access to a remote SQL server through ISA server
    ... Make a network trace on both sides (SQL1) and (SQL2). ... Use osql.exe connect to the remote server and execute sp_tables. ...
    (microsoft.public.sqlserver.security)
  • Transactional replication
    ... SQL1 and SQL2 ... These server are windows 2003 and sql 2000 and both located in different ... offices connected by a 100MB WAN link. ...
    (microsoft.public.sqlserver.replication)
  • Re: Merge result of two queries?
    ... 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 ... I am using the free version of SPAMfighter for private users. ... It has removed 452 spam emails to date. ...
    (comp.databases.oracle.misc)