Well, even a senior DBA has to add [schema name]
I just reproduced your issue.
When I ran on one of my databases
select top 1 * from [my database].[my table]
I got the identical error message about invalid object
When I ran
select top 1 * from [my database].dbo.[my table]
I got a valid query result.
It may be that you have not decribed the issue correctly and you mean to say, that you used USE [db name]
and then in select you mean to say
[schema name].[table name]
but as presented with XXX you say,
select .... from XXXX.XXXXX
so in your description the schma name is missing.