From: | "Mag Gam" <magawake(at)gmail(dot)com> |
---|---|
To: | "Frank Bax" <fbax(at)sympatico(dot)ca> |
Cc: | "PostgreSQL List - Novice" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Need help with INNER Join |
Date: | 2008-05-05 00:12:31 |
Message-ID: | 1cbd6f830805041712u54f33ecau4fd6c1a2ee69e7cb@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
All,
thanks for the help. I will try this.
TIA
On Sun, May 4, 2008 at 10:52 AM, Frank Bax <fbax(at)sympatico(dot)ca> wrote:
> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>
From | Date | Subject | |
---|---|---|---|
Next Message | Cody Konior | 2008-05-05 05:44:59 | Schema/Trigger help |
Previous Message | Frank Bax | 2008-05-04 14:52:38 | Re: Need help with INNER Join |