On Fri, Apr 27, 2007 at 09:18:59 -0600,
kvnsmnsn@cs.byu.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.