On Thu, 16 Jan 2003, 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. >
I like it! My sort of solution. Only I don't know the -u switch, I'd have done `cat blah* | sort | uniq` but it's obviously the same idea. As for the query that would do it, I believe that's already been answered I just thought I'd stand up for the good old fashioned unix ways. :) -- Nigel J. Andrews ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
