Useful little reminder...

-

Useful little reminder...

Originally shared by Philip Durbin

http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins

Comments

  1. Markus JoosApril 12, 2013 at 6:13 AM

    Excellent, thanks for sharing. For me as someone who is not dealing with DBs on a daily basis, such a reminder is very helpful.

    ReplyDelete
  2. Primož GabrijelčičApril 12, 2013 at 6:16 AM

    Beautiful, thanks!

    ReplyDelete
  3. Stefan MeisnerApril 12, 2013 at 6:22 AM

    The graphics to the upper left and the upper right are a bit misleading. They look like "select * from A" (left resp. "select * from B" (right). I have no real idea how to illustrate it better, though.
     Anyway, it's really helpful.

    ReplyDelete
  4. Kevin PowickApril 12, 2013 at 6:34 AM

    The linked article helps explain the diagram nicely and provides examples of each query type.

    ReplyDelete
  5. Ilya SApril 12, 2013 at 11:12 AM

    Can anyone draw a cross join?

    ReplyDelete
  6. Doug JohnsonApril 12, 2013 at 12:38 PM

    Cross join, no...but I can handle a really angry join and a mildly irritated join if that will help.

    ReplyDelete
  7. Ilya SApril 12, 2013 at 1:19 PM

    Thanks :) I think G+ might allow circling friends circles in circles like join circles at some point in future.

    ReplyDelete
  8. Doug JohnsonApril 12, 2013 at 1:28 PM

    Ilya S Good catch...this is the second time I've seen this today. I'm guessing Google is seeding the community so we won't all go ballistic when the new option becomes available.

    ReplyDelete
  9. Anthony FrazierApril 12, 2013 at 2:31 PM

    I'd like to see a similar diagram done for three table joins.

    ReplyDelete
  10. Doug JohnsonApril 12, 2013 at 2:47 PM

    Anthony Frazier  A Venn diagram done with SQL code. You, sir, are a masochist.  Or, possibly a sadist, since that is now going to haunt my weekend. Thank you so much

    ReplyDelete
  11. Anthony FrazierApril 12, 2013 at 2:51 PM

    Doug Johnson It was partially in jest, because I know that the series of diagrams would be nightmarish, but I am genuinely curious how they'd visualize.

    ReplyDelete
  12. Doug JohnsonApril 12, 2013 at 3:08 PM

    Anthony Frazier A Mandelbrot set comes to mind...then my brain melts

    ReplyDelete
  13. Anthony FrazierApril 12, 2013 at 3:12 PM

    LOL. :-D That's why I'm leaving it up to someone else to think hard about it. I've got enough brain melters on my plate.

    ReplyDelete
  14. Baoquan ZuoApril 12, 2013 at 10:10 PM

    I was very excited to distinguish these joins :D

    ReplyDelete

Post a Comment