>Hi,
> Is there any way to determine the number of tables is being used for the particular operation?? For example, select * from a, b, c
>how could i know there are 3 tables invloved?
Actually, there will be 4 tables involved in your example. For more information, see the article on Rushmore on my website.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer