Insert Does Not Map To Correct Fields

I have created 2 tables and populated them with data. When doing an inert into #JoblistTable from #EquentialJobListTable, fields are not mapped correctly. Example: qty_delivered in #JobListTable is filled with data from qty_received from #EquetialJobListTable?


CREATE TABLE#JobListTable
(
job_date datetime,
job_number char(15),
cost_code char(15),
qty_delivered decimal(8,2),
qty_received decimal(8,2),
qty_used decimal(8,2),
qty_wasted decimal(8,2),
plant_id char(10)
)
Fill table.........

CREATE TABLE#EquentialJobListTable
(
job_date datetime,
job_number char(15),
cost_code char(15),
qty_received decimal(8,2),
qty_used decimal(8,2),
qty_wasted decimal(8,2),
plant_id char(10)
)

Fill table .......


INSERT#JobListTable
(
job_date,
job_number,
cost_code,
qty_delivered,
qty_received,
qty_used,
qty_wasted,
plant_id
)
SELECTt2.job_date,
t2.job_number,
t2.cost_code,
t2.qty_received,
t2.qty_used,
t2.qty_wasted,
t2.plant_id,
case
when t2.plant_id = 320 then 'RGFP'
when t2.plant_id = 300 then 'RGWP'
when t2.plant_id = 600 then 'RGDF'
when t2.plant_id = 330 then 'RGGT'
when t2.plant_id = 350 then 'RGWG'
when t2.plant_id = 340 then 'RGDB'
when t2.plant_id = 610 then 'RGMI'
when t2.plant_id = 110 then 'SBGB2'
end
FROM#EquentialJobListTable AS t2
LEFT JOIN#JobListTable AS t1 ON
t1.job_date = t2.job_date
AND t1.job_number = t2.job_number
AND t1.cost_code = t2.cost_code
WHEREt1.job_date IS NULL