None of those answers look right to me ... what am I missing??
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.
If you are referring to the question:
Id_A Ds_A Id_B Ds_B
---- ----- ---- ----
1 A1 2 B1
2 A2 3 B2
3 A3 4 B3
On Id_A = Id_B
I would completely agree that none of the available answers is correct. Just to be sure I wasn't missing something, I tried each of the solutions; none produced the same result set as the join given above.
Unfortunately folks it was a trick question and the explination was incorrect.
MIDDLE will work because middle is neither a valid syntax or a keyword of any kind,
What is actually happening is the middle is being handled as the alias for Tab_A which is not what is being assumed.
basically we are being fooled with a trick of comprehension.
Viewing 3 posts - 1 through 2 (of 2 total)