haiao2000 thanks for your suggestion it ended up working. What i did was create a cursor and loaded it with each member_id then steped through the cursor and ran that...

I'm sorry, the first record in the enrollment table did NOT meet the query criteria but the second row did, i think it is stopping on the first failure or...

I tried your query but its not returning the right results, it seems like it is stopping after it hits the first records that meets the query conditions because the...

Why not use <= in the bottom phrase? Would this be considered a left outer join?

The problem is it is company data so i do not feel comfortable posting it online. Here is the long version:

We received a list of "purchases" from ABC Inc. that...