SQLServerCentral » Article Discussions » Article Discussions by Author » Discuss Content Posted by Gregory Larsen » Level 5: The Mathematics of SQL: Part 2InstantForum 2016-2 FinalSQLServerCentralhttps://www.sqlservercentral.com/Forums/SQLServerCentralThu, 27 Apr 2017 20:48:52 GMT20Level 5: The Mathematics of SQL: Part 2https://www.sqlservercentral.com/Forums/FindPost1170048.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Stairway+Series/75777/">Level 5: The Mathematics of SQL: Part 2</A>[/B]Wed, 30 Nov 2011 03:21:46 GMTGreg LarsenRE: Level 5: The Mathematics of SQL: Part 2https://www.sqlservercentral.com/Forums/FindPost1213773.aspxThanks Gregory
It's always useful to review the basics.
I think a mathematical set regards any identical member as being the same thing, so in the diagrams there would only be one representative of any number.
I don't know where that leaves us with UNION ALL though, it seems to break the rules.
I'm happy to be corrected, I just scraped through my maths degree.
CraigWed, 30 Nov 2011 03:21:46 GMTCraig Thomson-419971RE: Level 5: The Mathematics of SQL: Part 2https://www.sqlservercentral.com/Forums/FindPost1209060.aspx"as shown in the Venn diagram in Figure 5" should this be Figure 3?
"INNER JOIN operation to return part 2 of Figure 6" should this be Figure 4?Mon, 21 Nov 2011 01:04:25 GMTFiacre LenehanRE: Level 5: The Mathematics of SQL: Part 2https://www.sqlservercentral.com/Forums/FindPost1208513.aspxI reviewed the article text and your comment and I'm not following what part of the article has incorrect figure numbers. Would you please explain a little further so I can get the article corrected so it contains references to figures that a accurate.
Thank you
GregFri, 18 Nov 2011 10:15:22 GMTGreg LarsenRE: Level 5: The Mathematics of SQL: Part 2https://www.sqlservercentral.com/Forums/FindPost1206463.aspxA very clear and informative article. A minor point is that the Figure numbers appear to be incorrect in the INNER Join Operator and OUTER JOIN Operator sectionsWed, 16 Nov 2011 01:35:36 GMTFiacre Lenehan