List:General Discussion« Previous MessageNext Message »
From:Roger Baklund Date:August 15 2005 8:52am
Subject:Re: Question on Join
View as plain text  
Manoj wrote:
> Dear All,
>     I am trying to join two tables say a & b. Both tables have a set
> of dates. I want to join the tables in such a fashion that I retrieve
> all dates from table A. If table b has corresponding data (for that
> date) then it will display it or else will display null. I am pretty
> sure that I can solve this using left outer join but am not able to
> get it working hence any help would be appreciated!

Try something like this:

SELECT A.date,B.date
   FROM A LEFT JOIN B ON B.date=A.date

-- 
Roger

Thread
Question on JoinManoj15 Aug
  • Re: Question on JoinRoger Baklund15 Aug