Need help with a delete statement with joins

[Amin Baig]

Hi, I have the following sql statement in my trigger which is working fine:

INSERT INTO campaignplacedenom (id, campaign_id, campaignName, place_id, placeName) select new.id, new.campaign_id, campaignName, new.place_id, placeName from campaign pd join place pm on pm.id = new.place_id where pd.id = new.campaign_id


Can you guys help me with what should be the delete statement in the trigger and the update statement?

I am very new to mysql and having issues.

Thanks in advance.