Cross Join

SQL CROSS JOIN

The CROSS JOIN returns the Cartesian product of the tables involved in the join.

SQL Cross Join syntax

SELECT column_name(s)
FROM A_table CROSS JOIN B_table;

Test1

IDTITLE
1aaa
2bbb
3ccc

Test2

IDTITLE
1ttt
2qqq

Example

SELECT *
FROM Test1 
CROSS JOIN Test2;

Results

IDTITLEIDTITLE
1aaa1ttt
2bbb1ttt
3ccc1ttt
1aaa2qqq
2bbb2qqq
3ccc2qqq