CROSS JOIN is used to combine all rows present in one table with all rows present in another table. CROSS JOIN is also called as CARTESIGN JOIN.

SELECT column1,column2 FROM table1 CROSS JOIN table2;

SELECT column1,column2 FROM  table1, table2;

Let us consider below table(s) as an example table(s) to frame the SQL query for getting the desired results.

Scenario – Combining rows from two tables by using CROSS JOIN.

Requirement - Combining rows from employee_details and department_details tables by using CROSS JOIN with specific columns. The query was as follows –

SELECT emp_id, emp_name, department_details.dept_name 
FROM employee_details CROSS JOIN department_details;

It can also written as follows the output same in both queries-

SELECT emp_id, emp_name, department_details.dept_name 
FROM employee_details, department_details;

By executing above query we can combine all rows present in employee_details with all rows present in department_details table. The output was as follows –

Scenario – Combining rows from two tables by using CROSS JOIN with WHERE clause.

Requirement - Combining rows from employee_details and department_details tables of specific columns by using CROSS JOIN with WHERE clause. The query was as follows –

SELECT emp_id,emp_name,department_details.dept_name 
FROM employee_details CROSS JOIN department_details 
WHERE employee_details.dept_id = 1000;

By executing above query we can get output like as follows -

Scenario – Combining rows from two tables by using CROSS JOIN with all columns.

Requirement - Combining rows from employee_details and department_details tables by using CROSS JOIN with all columns. The query was as follows –

SELECT * FROM employee_details CROSS JOIN department_details;

By executing above query we can combine all rows of all columns present in employee_details with all rows of all columns present in department_details table. The output was as follows –