Skip site navigation (1) Skip section navigation (2)

Re: Need help with INNER Join

From: Emil Obermayr <nobs(at)nobswolf(dot)info>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Need help with INNER Join
Date: 2008-05-04 14:52:13
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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 join c on ;

In that respect, also take a look on "join using" and "natural join".

In response to

pgsql-novice by date

Next:From: Frank BaxDate: 2008-05-04 14:52:38
Subject: Re: Need help with INNER Join
Previous:From: Mag GamDate: 2008-05-04 14:40:05
Subject: Need help with INNER Join

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group