| From: | Justin Long <justinlong(at)strategicnetwork(dot)org> |
|---|---|
| To: | "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | SQL syntax for updating tables |
| Date: | 2000-04-07 19:46:04 |
| Message-ID: | 01BFA0A8.629AB840.justinlong@strategicnetwork.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
I'm trying to figure this out and I'm stumped. Perhaps someone else has
done it.
I have two tables:
SIGMEMBER
and
MEMBER
The MEMBER table has a USERID field and an EMAIL field. SIGMEMBER has the
same two fields. I am trying to update SIGMEMBER from MEMBER such that when
member.userid = sigmember.userid, it replaces sigmember.email with
member.email.
Any suggestions?
_____
Justin Long
Network for Strategic Missions
1732 South Park Court, Chesapeake, VA 23320
Ofc 757-420-4500, Fax 757-226-5006, Email justinlong(at)strategicnetwork(dot)org
Never retreat. Never surrender. Never cut a deal with a dragon.
http://www.strategicnetwork.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | tjk@tksoft.com | 2000-04-07 22:42:01 | Re: update only if single row |
| Previous Message | Andrew Perrin - Demography | 2000-04-07 19:12:39 | Speeding up a query |