PostgreSQL Cross Join
The CROSS JOIN matches every row of the first table with every row of the second table. It is also known as Cartesian product join. If the table1 has "x" columns and table2 has "y" columns then the resultant table will has the (x+y) columns.
See this example:
Let's take a table "EMPLOYEES" having the following data.
Create another table "DEPARTMENT" having the following data.
Execute the following query: