---

Cross join

---

A cross join is a Cartesian product in database.

Syntax and Example of Cross Join

We have Two given table name table1 and table2 and how the cross join.

Table1

Table2

Cross Join of These tables

select * from table1,table2; (non ansi type)
select * from table1 cross join table2; (ANSI type)

Output of non ansi type Cross Join

---

Output of ansi type Cross Join

---

---