Re: SQL UPDATE using INNER JOIN?

Rob,

 trying to do an UPDATE to a table using data from another table.

X1.B should end up with a value of 7.00




On 1/16/06, rob@xxxxxxxxx <rob@xxxxxxxxx> wrote:
>
> What are you trying to do, post data from one file to another, or what?
> Here are some sample files.  What should it end up as?
>
> select * from x1
> ....+....1....+....2....+...
> MYCHAR                 MYDEC
> A                     1.00
> B                     2.00
> C                     3.00
> ********  End of data  *****
>
> select * from x2
> ....+....1....+....2....+...
> MYCHAR                 MYDEC
> B                     7.00
> D                     9.00
> ********  End of data  *****
>
>
>
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> Ron Adams <rondadams@xxxxxxxxx>
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 01/16/2006 04:21 PM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
>
>
> To
> MIDRANGE-L@xxxxxxxxxxxx
> cc
>
> Fax to
>
> Subject
> SQL UPDATE using INNER JOIN?
>
>
>
>
>
>
> I'm trying to don an UPDATE to a table using data from another table and
> using the INNER JOIN clause. Can anyone show me a working example of this
> because I can't seem to get it right.
> --
> 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.
>
>