... FROM table1 a, table2 b WHERE rownum <= 10 ...