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. on-clause cross-join inner-join join MySQL
Login in to like
Login in to comment