UPDATE TABLE WITH DATA SELECT IN THE TABLE

[serenella angelilli]

Hi
i create a temporary table in this step:

CREATE TEMPORARY TABLE IF NOT EXISTS tmp_update AS (
SELECT i.id, i.is_active FROM cg_hs_subscriber_ibans i
JOIN cg_hs_subscribers s on s.id = i.subscriber_id
JOIN cg_hs_groups g on g.id = s.group_id
LEFT JOIN cg_hs_hss h on h.id = g.hs_id
WHERE h.id = 2 and i.is_active = 0
);

and after i create this step:


UPDATE cg_hs_subscriber_ibans SET is_active = 1
WHERE subscriber_id IN (SELECT id FROM tmp_update);


the update don't work! please help me!