RE: Update Column in one table with value from another table using SQL

The reply DOES allow multiple file access.  Providing you are running V4R3.




jewellcj@jewellconsult.com on 04/10/99 09:52:46 AM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     MIDRANGE-L@midrange.com@Internet
cc:      

Subject:        RE: Update Column in one table with value from another table 
using SQL

Joe:

Unfortunately the UPDATE statement does not allow multiple file access.

If you're using embedded SQL, then the best thing to do is to put your
update in a FETCH NEXT loop.

Chris Jewell

> -----Original Message-----
> From: owner-midrange-l@midrange.com
> [mailto:owner-midrange-l@midrange.com]On Behalf Of Joe Giusto
> Sent: Tuesday, April 06, 1999 4:28 PM
> To: 'midrange-l@midrange.com'
> Subject: Update Column in one table with value from another table using
> SQL
>
>
> How can I update a column in table1 with the value of a column in table2?
> Both tables have a unique index on account number.
>
> I tried Update table1 set column = (select colum2 from table2 where
> table2.acct = table1.acct)
>
> No luck.  I thought I have done something like this before but can not
> remember the correct syntax.
>
> Any help would be greatly appreciated.
>
> Joe Giusto II
> Patuxent Publishing Company
>  <mailto:jgiusto@patuxent.com> mailto:JGiusto@patuxent.com
> http://www.lifegoeson.com <http://lifegoeson.com>
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
>

Christopher J. Jewell.vcf