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

Re: WHERE AND JOIN STATEMENTS

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: WHERE AND JOIN STATEMENTS
Date: 2010-03-05 22:02:55
Message-ID: hmrv2f$849$2@reversiblemaps.ath.cx (view raw or flat)
Thread:
Lists: pgsql-novice
On 2010-03-05, JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> wrote:
> --000e0cdf986cab962e048111beb4
> Content-Type: text/plain; charset=ISO-8859-1
>
> What is the advantage (or advantages) of using JOIN instead of WHERE in a
> SELECT statement?
> Is JOIN faster than WHERE?

Join is IMO easier to read, also asier to change if you want left 
join instead etc.


In response to

pgsql-novice by date

Next:From: Tim LandscheidtDate: 2010-03-06 01:20:06
Subject: Re: WHERE AND JOIN STATEMENTS
Previous:From: Jasen BettsDate: 2010-03-05 21:27:02
Subject: Re: are primary keys always 'needed'

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