CROSS JOINs

---

A CROSS JOIN is basically a JOIN between two tables without a join condition. The result table is the Cartesian product of the two tables.

Syntax

The syntax for CROSS JOIN is as follows:

Example

 SELECT * FROM salaries CROSS JOIN employees
 WHERE salaries.emp_no = 133 OR employees.emp_no = 147
 

Mimer SQL Engine
The CROSS JOIN syntax is not supported.

Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se