October 21, 2004 at 7:53 am
None of those answers look right to me ... what am I missing??
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
October 21, 2004 at 10:31 am
If you are referring to the question:
Tab_A Tab_B
Id_A Ds_A Id_B Ds_B
---- ----- ---- ----
1 A1 2 B1
2 A2 3 B2
3 A3 4 B3
Select Id_A,Id_B,Ds_A,Ds_B
from Tab_A
Join Tab_B
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.
October 21, 2004 at 11:36 am
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)
You must be logged in to reply to this topic. Login to reply