Celko,

Thank you for your reply. I'm familiar with your work and am honored that you took the time to reply to this post. If you have a way to utilize EXISTS() (or TOP) to solve the query problem, then I hope you will share it. I would be very interested in that type of solution.

Lynn,

Thank you for your reply. It made me realize that my description of the result I was looking for was not accurate. I should have said:

I need a query to find "All Sales that are active at the same time and have at least one Location in common and at least one Item in common."

Forgive me for that. I'll try to edit my original post.