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 05, 2011 11:22 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Saturday, April 12, 2014 6:50 AM
Points: 1,040, Visits: 274
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 04, 2013 8:02 AM
Points: 330, 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: Saturday, April 12, 2014 6:50 AM
Points: 1,040, Visits: 274
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 04, 2013 8:02 AM
Points: 330, 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: Thursday, March 27, 2014 9:54 AM
Points: 185, Visits: 280
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