Re: MySQL question

On Tue, 8 May 2012 12:35:39 pm Arjen Lentz wrote:

Commonly, perceived need for DISTINCT tends to indicate a flawed query construct.

Agreed, but there are exceptions to every rule! While I do use this myself I do try to resolve the cause first - often it's possible, but sometimes there's no simple (or efficient) solution. Plus you can always implement DISTINCT but put it on a todo list to analyze and rework the query later if you're really time constrained.