query

UPDATE calc_campaigns SET delete_flag = 1;
 
REPLACE INTO calc_campaigns
SELECT
	c.campaign_id, 
	0 AS delete_flag
FROM
	campaign c
INNER JOIN
	adserver_adition_sync_campaigns aasc ON (c.campaign_id = aasc.campaign_id);
 
DELETE FROM calc_campaigns WHERE delete_flag = 1;