my test tbls
cattbl dogtbl birdtbl
name name name
id -------> catid ---> dogid
id ---- id
so
dogtbl.catid = cattbl.id
birdtbl.dogid = dogtbl.id
my question is how i can use "left joins" to produce the results set with the names of
all three cat/dog/bird...
i've tried various derivatives of the following...
mysql> select cattbl.name as cat,
-> dogtbl.name as dog, birdtbl.name as bird
-> from dogtbl
-> left join cattbl on cattbl.id=dogtbl.catid
-> from birdtbl
-> left join dogtbl on birdtbl.dogid=dogtbl.id;
i keep getting an error complaining about the 2nd "from/left join"...
i know how to get the results using "where/and" logic... but i'm trying to get a
better feel of the "left join" process...
after looking at mysql/google, i'm still missing something...
any comments/criticisms appreciated..
thanks
-bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
