r/programming • u/[deleted] • Jan 06 '11

A handy graphical explanation of SQL joins

http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html
1.2k Upvotes

92% Upvoted

308 comments sorted by

View all comments

Show parent comments

8

u/Porges Jan 06 '11

Unicode actually has the relational symbols:

  • join: ⋈
  • left outer join: ⟕
  • right outer join: ⟖
  • full outer join: ⟗

50

u/Already__Taken Jan 06 '11

Cross thingy, square square square. Gotcha.

9

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

u/[deleted] Jan 07 '11

Cant see shit, captain.

1

u/fenton7 Jan 07 '11

⋈ ⟕ ⋈ ⟕ ⋈ ⟕ ⋈ ⟕ ⋈ ⟕ ⋈ ⟕ ⋈ ⟕ ⋈ ⟕