Postgres Pro
Downloads
Home   >   mailing lists

Difference between these two queries ? - Mailing list pgsql-general

From Nilesh Govindarajan
Subject Difference between these two queries ?
Date
Msg-id AANLkTinkR3ZE0y1KQWC6Ztfc_w1L3O7SlY7-y8p3X65V@mail.gmail.com
Whole thread Raw
Responses Re: [SQL] Difference between these two queries ?  (Sergey Konoplev <gray.ru@gmail.com>)
Re: [SQL] Difference between these two queries ?  ("Little, Douglas" <DOUGLAS.LITTLE@orbitz.com>)
Re: Difference between these two queries ?  (Nilesh Govindarajan <lists@itech7.com>)
List pgsql-general
Tree view 
Hi,
I have a doubt about JOINS.

What is the difference between:

1. SELECT b.* from banners b, banners_users bu where b.id = bu.bid and
bu.uid = 5;

2. SELECT b.* from banners b INNER JOIN banners_users bu ON b.id =
bu.bid AND bu.uid = 5;

What is the first type of join called ?

and is it possible that they have different execution times ?

--
Nilesh Govindarajan
Facebook: nilesh.gr
Twitter: nileshgr
Website: www.itech7.com
Cheap and Reliable VPS Hosting: http://j.mp/arHk5e

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Dell Poweredge server and Postgres
Next
From: Scott Marlowe
Date:
Subject: Re: Dell Poweredge server and Postgres