Explicit syntax for select xxx from table1,table2

Question

I have a select statement

select someFields from table1,table2

which is a cartesian join, right? What's the explicit syntax for such a join. Searching the web for , isn't yielding much luck.

Answer 1

Cartesian join aka cross-join:

SELECT somefields FROM table1 CROSS JOIN table2

is a part of ANSI standard SQL:1992.