RE: Update with join

["Dan Kimmel" <dkimmel@xxxxxxxxxxxxxxx>]

I just learned this. Happy to pass it on.

update file1 set (fld1, fld2) = (select fld1, fld2 from file2 where
file1.fld11 = file2.fld11 and ...) 

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Servizi Aziendali
- Massimo Ceroni
Sent: Thursday, February 04, 2010 8:04 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Update with join


Hi.
I know I can update a table this way

UPDATE file1
SET file1.fld1=
(select file2.fld1 from file2
where file2.fld11=file1.fld11)

but I need to update more than one field  at a time like this

UPDATE file1
SET file1.fld1=file2.fld1, file1.fld2=file2.fld2 ...
WHERE file2.fld11=file1.fld11 and file2.fld12=file1.fld12

Thanks for any help

Massimo Ceroni
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.