SQL - Outer Join 2 queries?

Posted by Stuav on Stack Overflow See other posts from Stack Overflow or by Stuav
Published on 2012-09-20T21:34:31Z Indexed on 2012/09/20 21:37 UTC
Read the original article Hit count: 263

Filed under:
|

I have two querys. Query 1 gives me this result:

   Day        New_Users
01-Jan-12       45
02-Jan-12       36

and so on.

Query 2 gives me this result:

   Day       Retained_Users
01-Jan-12       33
02-Jan-12       30

and so on.

I want a new query that will join this together and read:

   Day        New_Users   Retained_Users
01-Jan-12       45           33
02-Jan-12       36           30

Do I use some sort of outer join?

© Stack Overflow or respective owner

Related posts about sql

Related posts about Oracle