You only need to specify from tabel on the first table. Like this.
select
cattbl.name as cat, dogtbl.name as dog, birdtbl.name as bird
from dogtbl
left join cattbl on cattbl.id=dogtbl.catid
left join birdtbl on birdtbl.dogid=dogtbl.id;
-Eric
On Mon, 5 Jul 2004 09:28:02 -0700, bruce <bedouglas@stripped> wrote:
> 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/mysql?unsub=1
>
>
