SELECT * from T1, T2
Cross Join: If T1 has N rows, T2 has M rows, the result set will have N x M rows.
If T2 has no row, then result of the JOIN has no row also.
However, I want N rows (from T1), what can I do?
Note: I want cartesian product, there is no shared column between the tables.