I have two files that I have been working with, IMSTKPF (Primary) and QQRYOUT. IMSTKPF file has a field called Price I am attempting to do a Join to theses to files to pull the value from the field TOTAL2 in the QQRYOUT file and update the PRICE field in THE IMSTKPF file.
I can’t seem to make this work. I update files all the time using the same method I have just never had to update every row of a file using Join criteria. Any guidance and help would be appreciated
SQL:
update qday.IMSTKPF as v1
set v1.PRICE =
(select v2.TOTAL2
from QDAY.QQRYOUT as v2
where v2.ARCSTK# = v1.STKPRT)