Can this be done in SQL (1 SQL statement)??
Posted on 2013-11-08
I have a table in Access called wholesalers_and_retailers, containing wholesaler_id & retailer_id.
Most wholesalers service only 1 retailer. However, there are some exceptions.
I'm trying to identify wholesalers which service more than one retailer, but only if one of the retailers has a retailer_id = 337.
I can't figure out where to start.
Should I first query all records which have a retailer_id= 337, and send the results to a temp table? Then somehow join that list of wholesalers to the main table, but only if the retailer_id is NOT 337?
I'm at a a loss; any suggestions would be very much appreciated !!!