[ANSWERED] Customer must own all 3 products

a clear sign of an inefficient, clumsy query – it may produce the right results with DISTINCT added, but it stinks, no offence

@oddz beat me to it, the better query is GROUP BY HAVING COUNT(*)=3