Hi Gad,
this syntax is not SQL Standard, so I assume any RFE for that will be
denied.
The correct Syntax for an update is:
Update Table a
Set UpdFld = (Select Fld
From Table2 b
Where a.Key1 = b.Key1
and a.Key2 = b.Key2 ?
and a.KeyN = b.KeyN)
Where Exists (Select Fld
from Table2 c
Where a.Key1 = c.Key1
and a.Key2 = c.Key2 ?
and a.KeyN = c.KeyN)
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Gad
Miron
Sent: Dienstag, 13. Oktober 2020 21:49
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: RFE for SQL update from
Hello sages
Does anybody know of an RFE for SQL to enable a from clause in SQL update
statement ?
like the way it's done in MS SQL SERVER TSQL.
update file_A
set file_A.field1 = file_B.field1
from file_A inner join file_B on file_B.key = file_A.key
TIA
Gad
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
