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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
