 | | | Question on Join | Question on Join 2005-08-15 - By Roger Baklund
Back
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/mysql?unsub=mysql@(protected)
Earn $52 per hosting referral at Lunarpages.
|
|
|