On Fri, Jan 17, 2003 at 08:57:14 -0500,
Andrew Perrin <clists(at)perrin(dot)socsci(dot)unc(dot)edu> wrote:
> I'd suggest something similar to, but slightly different from, what others
> SELECT DISTINCT email FROM (SELECT email FROM table_1 UNION SELECT
> email FROM table_2) AS combined;
> that way you avoid duplicates across tables.
The union operator already removes duplicates.
In response to
pgsql-admin by date
|Next:||From: Ross J. Reedstrom||Date: 2003-01-17 15:42:29|
|Subject: Re: Do Something before Abort on Trigger ???|
|Previous:||From: Andrew Perrin||Date: 2003-01-17 15:05:07|
|Subject: Re: OT: seeking query help, where?|