I want to express my sincere gratitude to all of you for the valuable help you have offered me here.

Thanks to your help, I have a solution now...

Dwain.c,

Thank you for all the effort you put into this.

I'm still searching for some way to limit the searching for common rows (common sale items or common sale locations) to...

Celko,

I really appreciate the idea. I tried it:

select ...

where EXISTS (select f1.item_id INTERSECT select f2.item_id)

It sounded like it could potentially offer...

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

Thank you both for your help with this.

I want to express my appreciation to all of you who replied to my post.

I'm grateful to all of you for taking the time to offer your help.

I would like to thank all of you who replied.

I found the common table expression solution submitted by shatrughna to be very useful.

I want to express my appreciation for your...