Hi Gail,

I had a chance to review the info you sent and on the link as well.

I can see how WITH CUBE and WITH ROLLUP.

I see that WITH ROLLUP adds...

Hi Gail,

You have sent me at least two posts that I want to look at carefully tomorrow. Thank you much for "looking out."...;)

I am...

Hi Gus, (and I'm Roberta not Roiberta as I mistyped-!)

I still like your tag name, I'm sure there's a company out there with that same name. ...

Hi Adam,

Thank you for your code samples, I have copied them into a Word doc to review. It's going to take a little time for me to really look...

Hi GSQuared,

Yes, it's Roiberta, the feminine version....; )

Besides that, I agree, that "seeing is believing."

I do have SQL Express Edition on my PC, so I will try

what you have...

Hi GSquared,

Thank you for the more visual explanation (apples) of the DISTINCT clause.

I definitely understand performance issues and how adding any additional search criteria will slow the DB down.

Seeing the...

Hi GSquared,

Thank you for your input. I am currently working with a tutor on the finer points before I go fo certification.

She and I were discussing this very same...

Hi Jeff,

Thanks for clearing up the gender thing, although my middle name

is Lynn....hhmmmm...:hehe:

Besides that, your addt'l info got my head swimming for the moment,

although I'll keep it for future reference.

Please...

Hi Gail,

Thank you for your additional input on the now infamous "IN"

portion of this statement. It was the one word that was

giving me pause....

As stated, I'll be submitting some...

Hi Matt,

Thank you for putting it in plain English. When it comes to syntax

I need to hear it in regular daily terms. This is the one area that

my...

Hi Jeff,

Thanks for weighing in re: Lynn's rewrite. Now, it makes more

sense to me, that hanging "IN" was throwing me off!

I'll be sending through some far meatier examples of...

Hello Lynn,

Thank you for your reply, it was really helpful.

I appreciate the "rewrite" in a JOIN query,

it is something I am familiar with as well, especially

in the (prod.CategoryID = cat.CategoryID)...

Thank you, your answer is straight and to the point.

The thing that looks odd to me is that after

WHERE CategoryID IN it looks like the query is sort

of hanging without...