Re: SQL Update with Select from Another file ?

<snip>
UPDATE UNICMFIL/SDVMSP SET SAJSAG = 0 WHERE SANMID in (SELECT CHGID FROM
CHGSDV0)

Searched but not finding anything as I need the Where to contain 2
fields
(not just the SANMID) .

Basically I would need the WHERE to be 2 fields SANMID and SAB8AA and
the
SELECT to be CHGID and CHGDIV.

i.e. SANMID=CHGID and SAB8AA=CHGIDV
</snip>

The proper way to do this is through a correlated sub-query. This could
be any number of fields.

Update SDVMSP u
Set AARCHD = 0
Where Exists (Select *
From CHGSDVO s
Where u.SANMID = s.CHGID And
u.SAB8AA = s.CHGDIV)