Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 Level 5: The Mathematics of SQL: Part 2 Rate Topic Display Mode Topic Options
Author
 Message
 Posted Monday, September 5, 2011 11:22 AM
 Ten Centuries Group: General Forum Members Last Login: Wednesday, August 17, 2016 10:41 PM Points: 1,043, Visits: 290
 Comments posted to this topic are about the item Level 5: The Mathematics of SQL: Part 2 Gregory A. Larsen, MVP
Post #1170048
 Posted Wednesday, November 16, 2011 1:35 AM
 Old Hand Group: General Forum Members Last Login: Friday, April 17, 2015 3:02 PM Points: 354, Visits: 160
 A 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 sections
Post #1206463
 Posted Friday, November 18, 2011 10:15 AM
 Ten Centuries Group: General Forum Members Last Login: Wednesday, August 17, 2016 10:41 PM Points: 1,043, Visits: 290
 I 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 youGreg Gregory A. Larsen, MVP
Post #1208513
 Posted Monday, November 21, 2011 1:04 AM
 Old Hand Group: General Forum Members Last Login: Friday, April 17, 2015 3:02 PM Points: 354, Visits: 160
 "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?
Post #1209060
 Posted Wednesday, November 30, 2011 3:21 AM
 SSC Veteran Group: General Forum Members Last Login: Friday, November 11, 2016 7:06 AM Points: 207, Visits: 375
 Thanks GregoryIt'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.Craig
Post #1213773

 Permissions