| From: | Nilesh Govindarajan <lists(at)itech7(dot)com> |
|---|---|
| To: | PostgreSQL SQL <pgsql-sql(at)postgresql(dot)org>, PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Difference between these two queries ? |
| Date: | 2010-06-06 02:30:46 |
| Message-ID: | AANLkTinkR3ZE0y1KQWC6Ztfc_w1L3O7SlY7-y8p3X65V@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2010-06-06 03:38:36 | Re: Dell Poweredge server and Postgres |
| Previous Message | John R Pierce | 2010-06-06 01:20:07 | Re: Dell Poweredge server and Postgres |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergey Konoplev | 2010-06-06 09:04:33 | Re: [SQL] Difference between these two queries ? |
| Previous Message | Oliveiros d'Azevedo Cristina | 2010-06-04 13:44:24 | Re: sum an alias |