migrating calendarnotes entries to corresponding lodge records

Working from an old db the following SQL was used to migrate calendarnotes to their new home:

UPDATE `q368l_motekalender_lodges` `lodges`
LEFT JOIN `q368l_motekalender_years` `years` ON `years`.`lodge_id`=`lodges`.`id`
SET `lodges`.`calendarnotes`=`years`.`calendarnotes`;