Report Help Troubleshoot Difficult Task in General Questions Posted July 15 Hi @pmcfarlain, While I didn't grasp all the details you provided, I can make some suggestions to improve your task: 1) Modify WHERE in UPDATE clause to specify which records in tbl_ggl_job_lines_days table should exactly get updated. Since there is no reference to any fields from tbl_ggl_job_lines_days, the one value that is returned from SELECT will get updated to all the records in that table. Here is one example you can refer to: This will update only the records where the IDs in both tables match. 2) Modify SELECT query and add the joins that you have added below in the UPDATE part to this query including WHERE Unit_Type = "FREIGHT". I am not sure if you need to add these joins only in SELECT query or add in both SELECT and UPDATE but they have to be added in SELECT query for sure. I hope this helps.