Help on an Update statement for select records [message #383861] |
Fri, 30 January 2009 15:43  |
mjchevalier
Messages: 2 Registered: January 2009
|
Junior Member |
|
|
I am in an implementation of a new software system and have to update an Oracle file using sql. Please help me with the code. I need to update all records in CUSTITEM table with the QTY value from the CUSTITEMUOM table where the ITEM from the CUSTITEM table = the ITEM from the CUSTITEMUOM table and where the SEQUENCE value from the CUSTITEMUOM table = 10 and where the FROMUOM value from the CUSTITEMUOM table = 'PCS'. Is this clear? Can someone help me? I understand a basic UPDATE statement but not one based on values from another table. Thank you very much!
|
|
|
|
|
|
|