Delete not working in a multi table join

[Anand Nair]

Hello, I believe this is the right forum to post this topic.

I have the following delete statement to delete records from two tables.

delete A, B
from catalog.Abins as A inner join catalog.Bins as B
where A.cdid = B.cdid
and A.item = B.item
and A.recordst = 'Cataloged';

When executing from both Workbench and commandline, getting the error '1046 - No database selected'. However, when removing A and B and replaced with full qualified table names (like catalog.Abins) the query is working. Is there anything wrong in the query or a problem with MySQL?

Appreciate any advises.