What is a cross Join

What is a cross join ? Cross join is defined as the cartesian product of records from the tables present in the join. Cross join will produce result which combines each row from the first table with the each row from the second table. Example :- SELECT last_name, department_name FROM employees CROSS JOIN departments ;

Share this

Hemalata