Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


CROSS JOIN


A CROSS JOIN is basically an INNER 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
 (SELECT COUNT(*) AS store_count FROM stores)
 CROSS JOIN
 (SELECT COUNT(*) AS emp_count FROM employees)

Mimer
Mimer Information Technology AB
Phone: +46 18 780 92 00
info@mimer.com
Mimer SQL Documentation TOC PREV NEXT INDEX