query sinkron data agent reject to active

mail@pastecode.io avatar
unknown
pgsql
6 months ago
131 B
4
Indexable
Never
UPDATE agents
SET is_active = 1
WHERE (select count(*) from advertises where advertises.agent_id = agents.id) > 1 and is_active = 2
Leave a Comment