UPDATE immissionen, ( SELECT nabel.nabel_id AS id, ROUND(IFNULL(nabel.O3, -99)) AS o3, ROUND(IFNULL(nabel.NO2, -99)) AS no2, ROUND(IFNULL(nabel.SO2, -99)) AS so2, NOW()+0 AS bearbeitet FROM nabel WHERE nabel.date = ( SELECT MAX(date) FROM nabel ) ) AS t SET immissionen.o3 = t.o3, immissionen.no2 = t.no2, immissionen.so2 = t.so2, immissionen.bearbeitet = t.bearbeitet WHERE immissionen.id = t.id