migration.sql

update logs

set app_id = case when apps.id is not null then apps.id else 0 end


from logs l
left outer join apps
	on l.app_name = apps.name
	AND l.company_id = apps.company_id

where
	logs.id = l.id