Am Sonntag, 4. Mai 2008 schrieb Mag Gam:
> To my understanding, it is preferred to use the INNER JOIN keyword. I am
> able to INNER JOIN 2 tables, but I am not sure of the syntax for 3 or more
> tables. Can someone please show me an example for that ?
Just concatenate the joins, modern servers do not need hints by brackets and
select * from a join b on a.id=b.aid join c on b.id=c.bid ;
In that respect, also take a look on "join using" and "natural join".
In response to
pgsql-novice by date
|Next:||From: Frank Bax||Date: 2008-05-04 14:52:38|
|Subject: Re: Need help with INNER Join|
|Previous:||From: Mag Gam||Date: 2008-05-04 14:40:05|
|Subject: Need help with INNER Join|