Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id A1F42475C62
	for <pgsql-sql@postgresql.org>; Tue,  4 Jun 2002 16:40:10 -0400 (EDT)
Received: from wm13.nyc.untd.com (outbound-20.nyc.untd.com [64.136.20.100])
	by postgresql.org (Postfix) with ESMTP id B5C9847598D
	for <pgsql-sql@postgresql.org>; Tue,  4 Jun 2002 16:39:07 -0400 (EDT)
Received: from cookie.juno.com by cookie.juno.com for
	<"/TkDBi7JJ2b6tmw2z88AACtBAFC3xVTf4LXYFD4Fqim1h0b7qcVz4w==">
Received: (from pricem@juno.com)
	by wm13.nyc.untd.com (jqueuemail) id G4G4M98B;
	Tue, 04 Jun 2002 16:38:20 EDT
X-Original-From: "Matthew Price" <pricem@juno.com>
Date: Tue, 4 Jun 2002 20:37:30 GMT
To: pgsql-sql@postgresql.org
Cc: 
Subject: Updating a table from another table
X-Mailer: Juno Webmail Version 1.0
From: Matthew Price <pricem@juno.com>
Message-Id: <20020604.163820.15423.68377@wm13.nyc.untd.com>
X-Archive-Number: 200206/30
X-Sequence-Number: 7995

Howdy All,

I need to update many records in one table with data from another table that ultimately gets \copy-ed from an outside source.

customers:
custnum varchar(6),
name text,
canceldate date
...

cancels:
custnum varchar(6),
canceldate date


What is the right way to update the canceldate in the customers table from canceldate in the cancels table?  Is there a way to use update to iterate rather than making a mass change?

Thanks in advance,
Matthew




________________________________________________________________
GET INTERNET ACCESS FROM JUNO!
Juno offers FREE or PREMIUM Internet access for less!
Join Juno today!  For your FREE software, visit:
http://dl.www.juno.com/get/web/.