>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?
You may need to get a little more specific... the answer is a little obvious otherwise <g>.
Wayne
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown
