‹ BACK

JOIN, CROSS JOIN, and INNER JOIN in MySQL

In MySQL, JOIN, CROSS JOIN, and INNER JOIN are syntactic equivalents (they can replace each other). In standard SQL, they are not equivalent. INNER JOIN is used with an ON clause, CROSS JOIN is used otherwise.
join cross-join inner-join MySQL on-clause

To check your knowledge the following tests are recommended:
Check your sql sql skills.