https://stackoverflow.com/questions/3248531/mysql-update-query-using-a-left-join
Anonymous
Work your system no matter how imperfect, and modify it as you go.