On Thu, 2003-01-16 at 17:15, Tim Lynch wrote: > from two tables both with email_addr columns, i want a distinct list of all > email_addrs in one column. what i do now is select distinct on each and then > sort -u the results.
You want either pgsql-sql or pgsql-novice, both of which are mailing lists for PostgreSQL. The former would be exactly the correct forum. Odds are someone in this list will answer you anyway with something mostly-useful. I think the UNION clause will help you to your eventual goal. -- Tim Ellis Senior Database Architect ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
