Need help with SQL statement

["Coleman, Katherine" <KColeman@xxxxxxxxx>]

Cutting my teeth on some SQL - but may be way out in left field!!

Want to join table A to table B and update a column in table A with the
value of a column in table B.   I am stuck 'cuz it wont let me refernce a
field name from my SELECT subqry on the SET command in the update statement.
My redbook and my manual (I really tried to look this up!!) only have
examples where the SET statement is setting = to a constant (eg. COST =
10.00) or to a calculation (eg. COST = (COST * .10)).  It is spitting at me
on the SET statement and saying "Column qualifier or table FILEB undefined."
I am not doing this in a pgm yet.  Doing it online because I wanted to get
my syntax right first. 

Here is my statement - please dont laugh!! :-)
                                               

 UPDATE FILEA 
      SET COST = FILEB.COST 
      WHERE VENDOR = '458182' AND EXISTS     
          (SELECT * FROM FILEB WHERE FILEB.STOCK# =         
           FILEA.STOCK#)

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---