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: 317
        
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