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 <[EMAIL PRO
On Monday 05 July 2004 12:28 pm, bruce wrote:
> my test tbls
>
> cattbl dogtbl birdtbl
> namename name
> id ---> catid ---> dogid
> id id
>
> so
> dogtbl.catid = cattbl.id
> birdtbl.dogid = dogtbl.id
>
> my question is how i can use "