query sync project

mail@pastecode.io avatar
unknown
pgsql
a month ago
284 B
5
Indexable
Never
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;
Leave a Comment