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

Cartesian product. Each row in table one is matched up to each row in table two.

Answer 2

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

More info on this, applied to SQL.