Re: Need help with INNER Join

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 
such:

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".

-- 
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice