Report question

Question: MySQL Update Query using a left join