Applications.ge

CROSS JOIN

CROSS JOIN

is the same as

INNER

implicit

joins. Without conditions, both result in Cartesian product:

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

JOIN

example:

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

JOIN

is the short form of

INNER JOIN

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

Implicit

join example

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

Both the queries return the exact same result

by Valeri Tandilashvili

MySQL

CROSS JOIN

MySQL Tutorial for Beginners

Pro tip: use ```triple backticks around text``` to write in code fences