Updating a table from another table - Mailing list pgsql-sql

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
wayto 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/.