Is there something wrong with joins that don’t use the JOIN keyword in SQL or MySQL?

Mar 12, 2012   //   by phpfreelancer.biz   //   Blog, MySQL Tutorial  //  No Comments

When I started writing database queries I don’t know how to use the JOIN keyword yet and I just extended

Here’s the SQL code:

 SELECT * FROM people p JOIN companies c ON p.companyID = c.id WHERE p.firstName = 'john' 

use the join keyword to link the primary keys and foreign keys

using the keywords will most probably make the code more readable/maintainable.

Leave a comment

Share This Post

RSS Wordpress News