I would appreciate coaching on this update, as I can't seem to make it work.

Each planning period I get a csv file that has ITEM ID and ITEM Available Quantity. I need to get the 'available quantity' into my static ITEM maintenance table. I imported the .csv file into my database. It should match ITEM IDs or if it is a 'new' ITEM, import that ID.

ITEM TABLE

IMPORT CSV

Imported into ITEM IMPORT TABLE

I know I can join them on ITEM ID, but how do I structure the query to join and then update the ITEM table with the IMPORT TABLE Available Quantity?

Thanks.