That's equivalent to "SELECT * FROM table 1, table2". Indeed it isn't much interesting in most case without a join between both tables, something like "SELECT * FROM table1, table2 WHERE table1.field1 = table2.field2".
In 4GL, you can do this with
FOR EACH table1 NO-LOCK, EACH table2 OF...