Cross Joins

Contact Us or call 1-877-932-8228
Cross Joins

Cross Joins

Code Sample:

Joining-Tables/Demos/cross_join.sql
--
--Theta Join syntax
--
SELECT first_name, last_name, department_name
FROM employees, departments
ORDER BY first_name, last_name, department_name;

A cross join (or Cartesian Product) will return a result set where each row from the first table is combined with each row from the second table. This is not often required in practice and is used intentionally rather sparingly.

Next