16 MySQL Tutorial for Beginners: Explicit vs Implicit Syntax

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:

SCRIPT FOR THE EXAMPLES:

SUBSCRIBE!

FACEBOOK

GOOGLE+

[marino]

Do you know any implicit syntax for RIGHT and LEFT JOINS?

[syedmustafahaider]

bhai bhoot bhooot sukhriya samjany k lye Allah tumy abad rakhy