Re: removing duplicate entries in a <JOIN> statement

[Bruno Wolff III <bruno(at)wolff(dot)to>]

On Fri, Apr 27, 2007 at 09:18:59 -0600,
  kvnsmnsn(at)cs(dot)byu(dot)edu wrote:
> 
> The problem with this is that <def> has some duplicate entries, seve-
> ral occurrences of a row that has precisely the same column values as
> some other row in <def>, so I'm getting duplicate rows in table
> <output_table>.
> 
> This solves my problem, but it seems to take an enormous amount of
> time to execute.  Is this the best way to remove duplicate entries, or
> is there some other way?

You could try left joining abc with a subselect of abc obtained using IN.