Hey Gail,

Thanks for the "inside dope." I find what you said to be very interesting.

I have built queries using the ON portion of the syntax, although not often as of yet.

I will keep this info in my bag of tricks.

Also, I realized that since right now I am trying to figure out how to interpret a query piece by piece and then turn it into syntax, I need to submit a different type of post.

It's going to be called "Interpreting the Query" and ask some specific questions about "building" the syntax.

Your WITH CUBE and WITH ROLLUP link was especially helpful as it showed the result set tables and really helped me to "see" the thang.

Pls keep an eye out for the next post, "Interpreting the Query." Thanks!

-Roberta-