I was able to get the info into the second temp table OPENPO1

here is a my raw data (partial)

PLANTPLANT_DESCVENDOR

7010Coquitlam DCPR1

NOPENULLNOPE

NOPENULLNOPE

NOPENULLNOPE

NOPENULLNOPE

NOPENULL1014435

NOPENULL1014435

NOPENULL1014435

7012Chilliwack DCPR1 ...

upDATE Temp_OPENPO

SET PLANT_DESC = Temp_OPENPO1.PLANT_DESC

FROM ...

INSERT INTO Temp_OPENPO1

SELECT A.PLANT, A.PLANT_DESC FROM

Temp_OPENPO A

WHERE VENDOR = 'PR1'

this is my command to populate the temp table

I don;t know how to set that up. Iout the plant and plant desc into another temp table and I am trying to use that to popllaute the orginal temp...

There is more data that that but put that just for a start.. I need to populate all the rows with the plant and plant desrc. I wanted to use...