Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


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
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX