sycn log prop baru
update projects set logs = name || ' ' || province || ' ' || city || ' ' || subdistrict || ' ' || projects.desc || ' ' || (select office_agents.name from office_agents where office_agents.id = projects.office_id) where logs is null;
Leave a Comment