New version of MySQL causing problem with delete

[Sassoon Kosian]

I am puzzled, the below code has been working perfectly for a year until recently. MySQL got upgraded and it no longer works.

-----------------------------------------------------------------------
DELETE FROM dbname1.armexp USING dbname1.armexp a,
dbname2.ban_company b WHERE locate( b.bancompany, a.company) > 0;

------------------------------------------------------------------
The error message says:
#1109 - Unknown table 'armexp' in MULTI DELETE
But that's not true, the table has existed all along, it is a misleading
message, and I don't know the real reason.

I would appreciate if someone could help me identify what's causing the problem, and what code I could use to achieve the same result.


Thanks.