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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
