iiit.raju (6/19/2013)
I am thinking the answer is 4 but some are telling that the answer is 3.So can you plese tell me the correct answer with explanation.
Why don't you create and populate the tables, run the query and see which it is?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability