query sync project

UPDATE projects
            SET logs = projects.name || ' ' || projects.province || ' ' || projects.subdistrict || ' ' || projects.city
           || ' ' ||  (select office_agents.name from office_agents where office_agents.id = projects.office_id)
            where logs is not null;