Uh-oh, that didn't work. Because DISTINCT only eliminates duplicate rows, I still get the following result set (based on the sample data above):

BuyListingID   SellListingID    ProductID

1                 10                 1

1                 11                 1

2                 10                ...

Gee....it's that simple?

Thanks for the help!

Thanks for your help! I'm not sure why the query didn't work, however I was able to work around the problem by using a table variable to hold possible matches,...

Thanks a lot for everyone's help! That worked great.

ok, before I downloaded anything, I thought I would start by trying to bring in the MSDE tables via Access External data. However, when I try to set up MSDE...