Implicit JOIN syntax

SELECT 
    students.first_name,
    notes.*
FROM  
    `notes`,
    `students`
WHERE notes.student_id = students.id

The following explicit JOIN returns the same result as the above implicit one:

SELECT 
    students.first_name,
    notes.*
FROM `notes`
JOIN `students` ON notes.student_id = students.id

If we forget

WHERE

clause on implicit JOIN, we will get CROSS JOIN result

SELECT 
    students.*,
    notes.*
FROM  
    `notes`,
    `students

Which is the equivalent of the following explicit JOIN syntax:

SELECT 
    students.*,
    notes.*
FROM `notes`
JOIN `students

CONS

of the implicit JOIN is that chance is higher to forget

WHERE

clause