Lets see if I can describe what I need correctly - Say I have a set of records that have a days and amount columns, along with PK. Say I'm matching on days = 17 and amount = 175. However, this is an aggregate match. say there are 3 records like:
PK= 3, Days = 10, amount 100,
PK= 12, Days = 5, amount 50,
PK= 44, Days = 2, amount 25,
What I want returned in a query are the PK of 3, 12, and 44.