Re: SQL Update with Join

["Michael Ryan" <michaelrtr@xxxxxxxxx>]

Very nice guys...that's for the help. Now, for my edification, what's
the difference between Peter's, Alan's and Guy's approaches? Peter is
selecting one, right? And Alan is selecting any, but will get the
first (or only)? And Guy is doing a straight select? What's the
difference/advantage in using the EXISTS clause? Thanks!

On Jan 10, 2008 8:50 AM,  <GUY_HENZA@xxxxxxxxxxxxxx> wrote:
> update inv set inv.feat = (select wcs.feat from wcs where INV.VND = WCS.VND
> and INV.MDL = WCS.MDL)
>
> Regards,
>
> Guy
>
>
>
>
>                       "Michael Ryan"
>                       <michaelrtr@xxxxxxxx        To:       "Midrange Systems Technical Discussion" <MIDRANGE-l@xxxxxxxxxxxx>
>                       m>                          cc:
>                       Sent by:                    Subject:  SQL Update with Join
>                       midrange-l-bounces@m
>                       idrange.com
>
>
>                       01/10/2008 08:42 AM
>                       Please respond to
>                       Midrange Systems
>                       Technical Discussion
>
>
>
>
>
>
>
> I'm sure this is much easier than I'm making it, but I can't get what
> I want to work. Two tables, INV and WCS. I want to set the value of
> INV.FEAT to WCS.FEAT when INV.VND = WCS.VND and INV.MDL = WCS.MDL. So
> I'm tried both a join and a subselect, but I'm not getting the syntax
> right. How do I do this? Thanks!
> --
> 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.