Re: SQL Update with Select from Another file ?

["Mark Allen" <scprideandms@xxxxxxxxx>]

Thanks Rob, I forgot about that (don't do enough SQL except for quick
fixes of garbage/incorrect data....don't even ask)

On 5/15/07, rob@xxxxxxxxx <rob@xxxxxxxxx> wrote:
> 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.