News for hackers. Stuff that matters.
Re:A Visual Explanation of SQL Joins (2007) by epochwolf on Tuesday May 28, 2013 @02:02AM (#5778374)
It's good enough for a beginner to start with. Provided they know it's not the complete picture.
Re:A Visual Explanation of SQL Joins (2007) by quizotic on Tuesday May 28, 2013 @05:16AM (#5779015)
Really? Even if it NEVER produces the right answer? How is it useful then?

A [inner|left|right|outer|cross|natural|whatever] join B NEVER produces a result that is in either A or B. It produces something larger, that wasn't it A or B before.

It's like trying to describe the result of meiosis with a Venn diagram. It's the combinations that matter, and the combinations are not reflected in the Venn diagram.

Re:A Visual Explanation of SQL Joins (2007) by gburnett on Tuesday May 28, 2013 @11:08PM (#5784334)
It's not that the picture is incomplete. It is, I believe, that the picture is incorrect. Sets are not relations. This is a barrier to understanding for a beginner.