After all the opinions I think I will learn to use the inner join, but the IN statement is easier for me to debug and test...

I find this amazing the point in writing a query to me is to find the answer, the result set.  And in my case accuracy is extremely important, so if...

Ken

Thanks so much for your help, all is working fine for me

Jim

BTW, I like using the IN for this project, am doing a...

Thanks Aaron

I am still not clear and it is a work assignment, I want to link the three tables I mentioned above using the IN, so still not certain about...

But I want to use the IN with a count distinct at the top, want to learn please?

Ed and all:

Thanks so much, I got the book you mentioned and will do the exercises that the book presents.

The paradigm must be similar to DataStage, but the implementation seems...