Re: SQL Update with Select from Another file ?

You might want to search for "left inner join"

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Mark Allen" <scprideandms@xxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
05/15/2007 11:16 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
cc

Fax to

Subject
SQL Update with Select from Another file ?






OK, I've done this before but only when its a single field match as this:

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


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