Re: Need help with INNER Join - Mailing list pgsql-novice

Mag Gam wrote:

When I needed to join tables I always used the equal syntax (ie. SELECT id from foo,fee where id.foo=id.fee)
 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 ?

Your example will not work; you should have written:

SELECT foo.id from foo,fee where foo.id=fee.id

With inner join, this would be

SELECT foo.id FROM foo
INNER JOIN fee on foo.id=fee.id

Joining a third table would look like

SELECT foo.id FROM foo
INNER JOIN fee ON foo.id=fee.id
INNER JOIN bar ON bar.id=foo.id

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