How about this? Although i agree query might get longer when there would be more than 3 items

SELECT DISTINCT CustomerID

FROM #Purchase P

WHERE EXISTS (SELECT...