Untitled

update projects set agent_id = (select agent_id from advertises where project_id = projects.id limit 1) where projects.id is not null