Level 5: The Mathematics of SQL: Part 2

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Gregory Larsen » Level 5: The Mathematics of SQL: Part 2

Level 5: The Mathematics of SQL: Part 2

Rate Topic

Display Mode

Topic Options

Author

Message

Greg Larsen

Posted Monday, September 05, 2011 11:22 AM

Ten Centuries

Group: General Forum Members
Last Login: Saturday, January 19, 2013 8:28 AM
Points: 1,038, Visits: 255

Comments posted to this topic are about the item Level 5: The Mathematics of SQL: Part 2

Gregory A. Larsen, MVP

Need SQL Server Examples check out my website at http://www.sqlserverexamples.com

Post #1170048

Fiacre Lenehan

Posted Wednesday, November 16, 2011 1:35 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 8:09 AM
Points: 312, Visits: 150

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

Greg Larsen

Posted Friday, November 18, 2011 10:15 AM

Ten Centuries

Group: General Forum Members
Last Login: Saturday, January 19, 2013 8:28 AM
Points: 1,038, Visits: 255

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 you
Greg

Gregory A. Larsen, MVP

Need SQL Server Examples check out my website at http://www.sqlserverexamples.com

Post #1208513

Fiacre Lenehan

Posted Monday, November 21, 2011 1:04 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 8:09 AM
Points: 312, Visits: 150

"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

Craig Thomson-419971

Posted Wednesday, November 30, 2011 3:21 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 6:29 AM
Points: 150, Visits: 218

Thanks 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.

Craig

Post #1213773

« Prev Topic | Next Topic »

Permissions