Hi rbarryyoung,

Thank you for breaking down the "IN" and "EXISTS" definitions.

The thing is, I am just not quite there yet as far as knowing in advance what I would like the result set to look like.

Where I am is in trying to figure out how to interpret a query piece by piece and then turn it into syntax.

So, what I'm going to do is submit another post titled, "Interpreting the Query" and ask some specific questions about "building" the syntax.

Once I understand this more clearly, I will understand result sets more clearly. Also, SEEING a result set is always so much more helpful as Gail sent me for WITH CUBE and WITH ROLLUP.

Your explanations are simple and clear, so pls keep an eye out for the next post, "Interpreting the Query." Thanks!

-Roberta-