Re: Question on Join

2005-08-15 Thread Roger Baklund
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 prett

Question on Join

2005-08-14 Thread Manoj
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 c