delete all tables data
DELETE cdr,campaigns FROM cdr INNER JOIN campaigns ON campaigns.cp_name = cdr.call_cp WHERE cdr.call_cp =campaigns.cp_name
delete all records from table cdr and campaigns where where campaigns.cp_name and cdr.call_cp is equal A
DELETE cdr,campaigns FROM cdr INNER JOIN campaigns ON campaigns.cp_name = cdr.call_cp WHERE cdr.call_cp ='A';
