Tag Archive: SELECT FROM

Aug 02 2008

MySQL 5 Does Not Work With ‘Comma Joins’

SELECT * FROM users as u, user_details as d WHERE u.id = d.user_id A comma separated joins are not as efficient nor are they the norm in web development. SELECT * FROM users as u INNER JOIN user_details as d ON u.id = d.user_id Hope this helps!

Permanent link to this article: http://www.armenianeagle.com/2008/08/02/mysql-5-does-not-work-with-comma-joins/

http://pagead2.googlesyndication.com/pagead/show_ads.js