I have a use case to query 2 tables in a specific way.
Both tables have a single column.
Table 1 Column 1:
It is called
Select t1.column1,t2.column1 from Table1 t1 CROSS JOIN Table2 t2
It will produce the Cartesian product between two tables.