Received: from pooh.strategicnetwork.org (IDENT:root@pooh.strategicnetwork.org [159.26.242.70]) by hub.org (8.9.3/8.9.3) with ESMTP id PAA34772 for ; Fri, 7 Apr 2000 15:47:33 -0400 (EDT) (envelope-from justinlong@strategicnetwork.org) Received: from JDLONG (mid-tgn-mog-vty2.as.wcom.net [216.192.79.2]) by pooh.strategicnetwork.org (8.9.3/8.9.3) with SMTP id PAA26288 for ; Fri, 7 Apr 2000 15:47:29 -0400 Received: by localhost with Microsoft MAPI; Fri, 7 Apr 2000 15:46:05 -0400 Message-ID: <01BFA0A8.629AB840.justinlong@strategicnetwork.org> From: Justin Long Reply-To: "justinlong@strategicnetwork.org" To: "'pgsql-sql@postgresql.org'" Subject: SQL syntax for updating tables Date: Fri, 7 Apr 2000 15:46:04 -0400 Organization: Network for Strategic Missions X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Archive-Number: 200004/76 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@strategicnetwork.org Never retreat. Never surrender. Never cut a deal with a dragon. http://www.strategicnetwork.org