Resultset logic when selecting tables without a join?

Question

Dumb question.. what logic does the database use to determine the result set if you do a select without a join such as:

select * from table1, table2

Answer 1

It uses a cartesian product, it gives every possible combination of the two tables.

More info on this, applied to SQL.