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