Add lookups to update query

Transact-SQL
21

It doesn't look like the Insert CASE after the Update step is working correctly. I see records
not getting the correct PriseList when I look at the data from the Inserted table.

any thoughts?