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

WHERE AND JOIN STATEMENTS

From: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: WHERE AND JOIN STATEMENTS
Date: 2010-03-05 18:18:40
Message-ID: f03943a01003051018hceb485fm9cde3cc63f248f52@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
What is the advantage (or advantages) of using JOIN instead of WHERE in a
SELECT statement?
Is JOIN faster than WHERE?

I have a SELECT statement that involves 7 tables and I am using WHERE to
relate them and get the result I need but I want to know if there is a
performance issue if I change to JOIN.

Respectfully,
Jorge Maldonado

Responses

pgsql-novice by date

Next:From: Jure KobalDate: 2010-03-05 19:01:48
Subject: Re: WHERE AND JOIN STATEMENTS
Previous:From: venkatrao.bDate: 2010-03-05 12:19:38
Subject: Re: [NOVICE] Is there any oracle user_source table equivalent in postgre?

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