HI ALZDBA,

Thanks for the quick response.

I want to show you what I have based on what you stated.

SELECT drinker (drinker likes beer)

FROM likes, serves...

HI jezemine,

Thank you for the article, it is much closer to the idea that I've been having about "breaking it down" piece by piece.

At this moment, I am going...

Hello GS,

I apologize for the late response, I have been piled up big time...:exclamationmark:

I will look over your info tomorrow and respond.

Thank you again for your continued input...

-Roberta-

HI,

Sorry for the delayed response, I got piled up. Thanks for the explanation on the "ON" portion of the syntax. I'll keep it in my

stockpile.

I should be...

Hi again,

Jeff's post about CTE's and derived tables got my looking at your post again even thought I'm sending a new post on building queries.

I'd like to tell you what...

Hello Gail,

I have saved your info for a later date when I'm ready for it.

I am familiar with aliases and derived tables, however, not ready

for prime time yet.

Pls see my...

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...

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...

Hi NJ,

Thanks for the site, I hadn't noticed it before. I checked it out, and it looks like a good resource.

I am going to submit a different type of...

Hi NJ,

Believe it or not, I had that query as well as a 2nd option, and wasn't sure if it was correct.

In the meantime, I know now the complex query...

Hi Jeff,

Thanks for the post because you prompted me to pull up the site and then realize it was specifically related to WITH CUBE and WITH ROLLUP which I did...

Hi Paul,

After seeing Jeff Moden's post, I realized that you were pointing me to a specific area of the site for WITH CUBE and WITH ROLLUP which I actually hadn't...

Hi Paul,

Thanks for the tip, and YES, I do use it all the time. A classmate of mine in ASP.NET pointed it out to me.

However, I look to other...

Hi Damon,

Thank you for the link, currently I'm fine tuning my training by reviewing all notes and working with a tutor. The goal is to get a certificate.

I do...

Hi William,

Thank you for the tip. I had another member say the same thing and suggest purchasing the Developer edition for about $50 which I will do.

Right now, I...