Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where EXISTS (select 1 from conference_1 b where
a.BillingCode=b.billingcode a' at line 1
解决办法不使用别名 alias
delete from customer_billingcode_partylimit where EXISTS (select 1 from conference_1 where
customer_billingcode_partylimit.BillingCode=conference_1.billingcode and conference_1.CustomerCode='111111');
MYSQL 5 删除不支持别名 alias