> >Unless your query is going to be long enough to run into query length
> >limits, aliases are not your friends. Standard SQL they may be, but
> >aliases always end up obscuring queries to those who come along after
> >you.
>
> The problem is that it's difficult to refer to the same table twice
> in a single query without using aliases.
>
> The trap I fell into was thinking I had to alias both references to
> the table.
>
> I'd be interested in seeing alternative solutions to the duplicate
> removal problem.
Yes, that is tricky in that there is an aliased version and a non-alias
version of the same table.
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026