> from cwiki, the answer is no. it seems supported after some test. The old syntax doesn't support it, but the new one does.
select count(1) from table1, table2 where table1.x < table2.x; That said, that query won't run very fast unless one of the tables is tiny. Cheers, Gopal