NSC | SuiteQL: Join Types: CROSS JOIN

CROSS JOIN is a type of SQL join that combines every row from one table with every row from another table. It is also known as a Cartesian product, named after the mathematician René Descartes, who introduced the concept. The result of a cross join is a dataset that includes all possible combinations of rows between the two tables.

Sample Query:

Here is an example of a cross join between the "customer" and "employee" tables:

SELECT * FROM customer CROSS JOIN employee;

In this query, each customer record will be paired with every employee record, creating a comprehensive dataset.

When utilizing SuiteQL with SuiteAnalytics Connect, it should be noted that explicit CROSS JOIN syntax is