Logical logic when choosing tables without joining?

Question

Silent question .. what logic does the database use to determine the result set if you select without a connection, for example:

select * from table1, table2

Answer 1

It uses a Cartesian product , it gives any possible combination of two tables.

Additional information on this applies to SQL.

Answer 2

Cartesian product. Each row in the first table is mapped to each row in table 2.