Difference between these two queries ?

Поиск
Список
Период
Сортировка
От Nilesh Govindarajan
Тема Difference between these two queries ?
Дата
Msg-id AANLkTinkR3ZE0y1KQWC6Ztfc_w1L3O7SlY7-y8p3X65V@mail.gmail.com
обсуждение исходный текст
Ответы 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>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Dell Poweredge server and Postgres
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Dell Poweredge server and Postgres