16 MySQL Tutorial for Beginners: Explicit vs Implicit Syntax HD

When you use the implicit syntax for an inner join, you code the tables in the FROM clause separated by commas. Then, you code the join conditions in the WHERE clause. Note that the comparison is coded as the search condition of the WHERE clause. The implicit syntax was widely used before the introduction of the explicit syntax. Because the explicit syntax for joins lets you separate join conditions from search conditions, it’s typically easier to read. We therefore recommend that you use the explicit syntax in all your SQL code. EXERCISES for your SELF-TRAINING: http://www.golearnfast.com/exercises.php?group=0&lesson_id=293&category_id=926 SCRIPT FOR THE EXAMPLES: http://golearnfast.com/files/lessons/lesson_277_1440544998.sql SUBSCRIBE! https://www.youtube.com/channel/UCMEaGDoHU7c9tWyafZ9vC6Q?sub_confirmation=1 FACEBOOK https://www.facebook.com/golearnfast GOOGLE+ https://plus.google.com/u/0/b/101326338689489366802/