query sinkron data agent reject to active

 avatar
unknown
pgsql
2 years ago
131 B
7
Indexable
UPDATE agents
SET is_active = 1
WHERE (select count(*) from advertises where advertises.agent_id = agents.id) > 1 and is_active = 2
Editor is loading...
Leave a Comment