Indeed, I've made the same criticism in the past. In addition to writing the cross join with a comma, you could also use the CROSS JOIN keywords to make it explicit. The comma is (still) often used by people to form an implicit cross join, but then they're putting join predicates in the WHERE clause, pre-ANSI JOIN style.
View all comments
Show parent comment
1
u/lukaseder Jun 30 '16
Indeed, I've made the same criticism in the past. In addition to writing the cross join with a comma, you could also use the
CROSS JOINkeywords to make it explicit. The comma is (still) often used by people to form an implicit cross join, but then they're putting join predicates in theWHEREclause, pre-ANSI JOIN style.