×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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.
midrange.com
