Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Level 5: The Mathematics of SQL: Part 2 Expand / Collapse
Author
Message
Posted Monday, September 5, 2011 11:22 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, June 6, 2014 2:06 PM
Points: 1,040, Visits: 277
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
Posted Wednesday, November 16, 2011 1:35 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, December 4, 2013 8:02 AM
Points: 331, Visits: 158
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

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, June 6, 2014 2:06 PM
Points: 1,040, Visits: 277
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
Posted Monday, November 21, 2011 1:04 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, December 4, 2013 8:02 AM
Points: 331, Visits: 158
"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-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, October 13, 2014 4:26 AM
Points: 194, Visits: 308
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 »

Add to briefcase

Permissions Expand / Collapse