If you fix your syntax to
select * from table1, table2;
you will get a join where every condition is true, which is the same as the Cartesian product of the two tables.
table1 table2 ------ ------ A 1 B 2 C
A 1 A 2 B 1 B 2 C 1 C 2
solved What would be output of SQL query if we include two table without any condition