Re: OT: seeking query help, where? - Mailing list pgsql-admin

From Robert Treat
Subject Re: OT: seeking query help, where?
Date
Msg-id 1042758732.12025.19.camel@camel
Whole thread Raw
In response to OT: seeking query help, where?  ("Tim Lynch" <admin+pgsqladmin@thirdage.com>)
List pgsql-admin
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 majordomo@postgresql.org)




pgsql-admin by date:

Previous
From: Steve Crawford
Date:
Subject: Re: OT: seeking query help, where?
Next
From: "Devinder K Rajput"
Date:
Subject: Re: OT: seeking query help, where?