This is a postgresql DB. I have users in my users table that are associated with a customer entity by a customer_id column. The customer is broken down into smaller segments by department and the users are assigned to a department. It looks something like this.

I have one prod table and one temp.
The task: update all records in prod table with information from temp.