Postgres Pro
Downloads
Home   >   mailing lists

WHERE AND JOIN STATEMENTS - Mailing list pgsql-novice

From JORGE MALDONADO
Subject WHERE AND JOIN STATEMENTS
Date
Msg-id f03943a01003051018hceb485fm9cde3cc63f248f52@mail.gmail.com
Whole thread Raw
Responses Re: WHERE AND JOIN STATEMENTS  (Jure Kobal <j.kobal@gmx.com>)
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: venkatrao.b@tcs.com
Date:
Subject: Re: Is there any oracle user_source table equivalent in postgre?
Next
From: Jure Kobal
Date:
Subject: Re: WHERE AND JOIN STATEMENTS