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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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