I am preparing to take the 70-433 sometime this week and while doing a practice test last night I came over this question which the answer provided doesn't look correct to me. The question is as follows:
You have a table named Pets, which contains the following columns:
petName, which stores the name of the pet
ownerName, which stores the name of the pet's owner
You also have a table named Owners, which contains the following columns:
ownerName, which stores the name of the owner of one or more pets
age, which stores the age of the owner
location, which stores the name of the city in which the owner lives
You must retrieve the name of each pet whose owner is over the age of 50 and lives in Seattle.
The solution provided by the test was as follows:
Pets AS pet
I don't believe this is possible. The join is made on the ownerName column, but the derived tabled 'own' does not contain that column, therefore it cannot be referenced. I set up the example on SSMS and indeed, it did not
work. Is this answer wrong? Or am I missing something here? Thank you.
View Complete Post