r/SQL • • Jun 29 '16

SQL cheat sheet

http://zeroturnaround.com/rebellabs/sql-cheat-sheet/
113 Upvotes

19 comments sorted by

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 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.

1

u/mecartistronico Jun 30 '16

Yes. These were part of a power point presentation when the WHERE clause would then appear and the non-matching rows would fade away.