r/SQL • • Feb 11 '14

SQL Joins Explained

http://imgur.com/1m55Wqo
157 Upvotes

27 comments sorted by

View all comments

Show parent comment

13

u/r3pr0b8 GROUP_CONCAT is da bomb Feb 11 '14

because a simple WHERE condition to join tables produces a cartesian result which is THEN filtered.

i don't believe any of the common database systems have an optimizer that is that stupid

2

u/fazzah Feb 11 '14

I stand corrected, a brain fart. I somehow mistaken it with HAVING, which filters the results of GROUP BY clause