AS/400 SQL V5R2 — updating new fields in a file with values from a different file

AskDave

pts.

Tags:

SQL

I added 2 fields to FileA (FldX and FldY) FileA has the key to FileB (KeyB) where these values exist. FileA: FldA, FldB, KeyB, new... FldX, FldY FileB: BKeyB, BFldX, BFldY This is probably simple for someone that composes SQL all the time but I'm having trouble coming up with acceptable syntax... Thanks for any help you can provide... Dave

Asked: March 31, 2005 10:15 AM Last updated: April 1, 2005 8:18 AM

Answer Wiki

Last updated: April 1, 2005 3:35 AM GMT

AlastairDK0 pts.
History
Contributors
- Ordered by most recent
- AlastairDK0 pts.

Thanks. We'll let you know when a new response is added.

Hi Dave,

You need something like this:

Update FileA set FldX=(select BFldX from FileB where KeyB=BKeyB) , FldY=(select BFldY from FileB where KeyB=BKeyB).

Discuss This Question: 1 Reply

BigKat Apr 1, 2005 8:18 AM GMT

or more efficiently Update FileA A set (FldX, FldY)= (select BFldX, BFldY from FileB where BKeyB = A.KeyB)

9,110 pointsBadges:

report