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
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