UPDATE t_led_parkinglot INNER JOIN t_parkinglot ON t_led_parkinglot.temp=t_parkinglot.no SET t_led_parkinglot.parkinglotid=t_parkinglot.id