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;
Leave a Comment