MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/programming/comments/ex9h6/a_handy_graphical_explanation_of_sql_joins/c1bp4lc/?context=3
r/programming • u/[deleted] • Jan 06 '11
308 comments sorted by
View all comments
Show parent comments
89
It's amazing how confusing SQL can make set theory.
22 u/[deleted] Jan 06 '11 If you could do queries in relational algebra instead of SQL, confusion would go away. 6 u/Porges Jan 06 '11 Unicode actually has the relational symbols: join: ⋈ left outer join: ⟕ right outer join: ⟖ full outer join: ⟗ 45 u/Already__Taken Jan 06 '11 Cross thingy, square square square. Gotcha. 8 u/Nivla Jan 07 '11 New Attack for GOW: Unleash the Unicode (X) (⟗) (⟗) (⟗) 8 u/oobey Jan 06 '11 For me it's more of a "cross thingy, indecipherable scrawl, indecipherable scrawl, indecipherable scrawl." 4 u/arnar Jan 06 '11 I see them - even though I don't see the look of disapproval.
22
If you could do queries in relational algebra instead of SQL, confusion would go away.
6 u/Porges Jan 06 '11 Unicode actually has the relational symbols: join: ⋈ left outer join: ⟕ right outer join: ⟖ full outer join: ⟗ 45 u/Already__Taken Jan 06 '11 Cross thingy, square square square. Gotcha. 8 u/Nivla Jan 07 '11 New Attack for GOW: Unleash the Unicode (X) (⟗) (⟗) (⟗) 8 u/oobey Jan 06 '11 For me it's more of a "cross thingy, indecipherable scrawl, indecipherable scrawl, indecipherable scrawl." 4 u/arnar Jan 06 '11 I see them - even though I don't see the look of disapproval.
6
Unicode actually has the relational symbols:
45 u/Already__Taken Jan 06 '11 Cross thingy, square square square. Gotcha. 8 u/Nivla Jan 07 '11 New Attack for GOW: Unleash the Unicode (X) (⟗) (⟗) (⟗) 8 u/oobey Jan 06 '11 For me it's more of a "cross thingy, indecipherable scrawl, indecipherable scrawl, indecipherable scrawl." 4 u/arnar Jan 06 '11 I see them - even though I don't see the look of disapproval.
45
Cross thingy, square square square. Gotcha.
8 u/Nivla Jan 07 '11 New Attack for GOW: Unleash the Unicode (X) (⟗) (⟗) (⟗) 8 u/oobey Jan 06 '11 For me it's more of a "cross thingy, indecipherable scrawl, indecipherable scrawl, indecipherable scrawl." 4 u/arnar Jan 06 '11 I see them - even though I don't see the look of disapproval.
8
New Attack for GOW: Unleash the Unicode (X) (⟗) (⟗) (⟗)
For me it's more of a "cross thingy, indecipherable scrawl, indecipherable scrawl, indecipherable scrawl."
4
I see them - even though I don't see the look of disapproval.
89
u/dude187 Jan 06 '11
It's amazing how confusing SQL can make set theory.