update RecyclingRecord set recyclingApplicationType = (select type from invoicePlan where id = recyclingApplication_id) where (recyclingApplicationType is null or recyclingApplicationType = '');