SQL evaluation

[PIEBALDconsult]

I just took an online evaluation of my SQL skills (SQL-FU?). How would you answer this question: " Given the following SQL statement: SELECT customers.customerid, currentbalance FROM customers LEFT OUTER JOIN customer_balance ON customers.customerid = customer_balance.currentbalance Which of the following statements correctly describe the result set? A. Only customerid values with a matching value in the customer_balance table will be displayed in the result set. B. All currentbalance columns from the customer_balance table will be displayed in the result set. Customerid values will be displayed for each customerid with a matching value in the customers table. Null will be displayed as the value for currentbalance for all customerids with no match in the customer_balance table. C. All currentbalance columns from the customer_balance table will be displayed in the result set. Customerid values will be displayed for each customerid with a matching value in the customers table. A customerid value of null will be displayed for each customerid without a matching value in the customers table. D. All customerid columns from the customer_balance table will be displayed in the result set. Current balance values will be displayed for each customerid with a matching customerid value in the customer_balance table. Zero will be displayed as the value for current balance for all customerids with no match in the customer_balance table. E. All customerid columns from the customers table will be displayed in the result set. Current balance values will be displayed for each customerid with a matching customerid value in the customer_balance table. Null will be displayed as the value for current balance for all customerids with no match in the customer_balance table. " I decided that customers.customerid = customer_balance.currentbalance was a typo and chose E. Ah, well, at least I got 83rd percentile. :-D

[_Damian S_]

Assuming that it was a typo (which it must be since there was no option for "this is crap and if I can't pick this error up I shouldn't be using SQL"), then answer E is correct.

I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!