Report question

Question: MySql - Update table using select statment from same table