Even if you find a DBMS that runs it, it will produce a CROSS JOIN, i.e. a result set with as many records in table1 multiply by as many records in table2.

This is also known as a cartesian product. The query will produce that because there is no join information - i.e. no implicit link between the two tables in the WHERE clause, and no JOIN clause.

Michael