|
|
|
SSChampion
        
Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,040,
Visits: 1
|
|
| Comments posted to this topic are about the Question of the Day for 08 May 2007 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=1029.
|
|
|
|
|
Mr or Mrs. 500
      
Group: General Forum Members
Last Login: Tuesday, November 27, 2012 9:57 AM
Points: 502,
Visits: 212
|
|
So, what's wrong with this answer: "This returns all rows and all columns from both tables?" I think the wording on the "correct" answer, "This returns all rows from both tables, replacing the values for columns with NULL when a row does not have a match in a table", was a horrible rendition of the Microsoft documentation which states that "Any time a row has no match in the other table, the select list columns from the other table contain null values"
|
|
|
|
|
SSCrazy
      
Group: General Forum Members
Last Login: Sunday, May 19, 2013 7:02 PM
Points: 2,861,
Visits: 405
|
|
I agree with you. Even the first option "This returns all combinations of all rows in both tables based on the columns joined in the ON clause." is correct as well IMO. Non-matching rows is part of a combination. I just think the options are a bit vague.
Urbis, an urban transformation company
|
|
|
|
|
SSCommitted
      
Group: General Forum Members
Last Login: Monday, May 13, 2013 9:56 AM
Points: 1,808,
Visits: 369
|
|
| I completely agree with the previous comments. The options were poorly worded.
|
|
|
|
|
Right there with Babe
      
Group: General Forum Members
Last Login: Saturday, December 03, 2011 10:08 AM
Points: 769,
Visits: 187
|
|
| I have to agree on this one. Most of the answers would have been correct.
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Sunday, May 19, 2013 11:16 PM
Points: 1,061,
Visits: 1,151
|
|
got excite to see such a simple question and clicked on wrong option
|
|
|
|