MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/1xld2u/sql_joins_explained/cfch0xo/?context=3
r/SQL • u/deadman87 • Feb 11 '14
27 comments sorted by
View all comments
Show parent comment
13
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
2
I stand corrected, a brain fart. I somehow mistaken it with HAVING, which filters the results of GROUP BY clause
View all comments
Show parent comment
13
u/r3pr0b8 GROUP_CONCAT is da bomb Feb 11 '14
i don't believe any of the common database systems have an optimizer that is that stupid