Re: WHERE AND JOIN STATEMENTS - Mailing list pgsql-novice

On 2010-03-05, JORGE MALDONADO <jorgemal1960@gmail.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.