Need help with INNER Join

From: "Mag Gam" <magawake(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Need help with INNER Join
Date: 2008-05-04 14:40:05
Message-ID: 1cbd6f830805040740x207b8432s63e2d45248b37767@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello

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 ?

TIA

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Emil Obermayr 2008-05-04 14:52:13 Re: Need help with INNER Join
Previous Message Phillip Smith 2008-05-01 23:32:25 Re: Configuration on CentOS 4.6