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
