there are several ways to do this, one example would be: select distinct(email_addr) from table1 union select distinct(email_addr) from table2
You can ask questions like these on the pgsql-newbies or pgsql-sql lists if you'd like (though generally you shouldn't get flamed no matter which group you post to) Robert Treat On Thu, 2003-01-16 at 17:15, Tim Lynch wrote: > First, sorry for the OT, flame me off-list! > > I'm a sysadmin being impressed into dba service. i've been getting along > pretty well writing queries and making reports, but i've got some questions. > suggestions for a good list/forum for help? > > 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. > > thanks in advance > -t > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
