only4mithunc (6/8/2010)
Are you sure that all joins are possible if the Sub query comes in WHERE clause or in FROM clause as well..?
Yes. Why don't you test it out and see for yourself? Not hard to do.
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