UPDATE LOISStatistik2.dbo.KL_monitorering set ghetto_niveau=0

UPDATE M set M.lat=O.CentroidLat, M.long=O.CentroidLong, M.size=O.size FROM LOISStatistik2.dbo.KL_monitorering M INNER JOIN LOISStatistik2.dbo.KL_monitorering_omraader O ON M.MAP_ID=O.MAP_ID

-- UPDATE O set O.image_URL=H.image_URL FROM LOISStatistik2.dbo.KL_monitorering_omraader O INNER JOIN LOISStatistik2.dbo.HK_moni_omraader H ON H.MAP_ID=O.MAP_ID

UPDATE M set M.image_URL=O.image_URL FROM LOISStatistik2.dbo.KL_monitorering M INNER JOIN LOISStatistik2.dbo.KL_monitorering_omraader O ON M.MAP_ID=O.MAP_ID