Script out your table.

Maybe the table name exists twice, one in its own schema.

Maybe you are querying a view of the table.

So, script out the table with schema names, script out the insert for the data you are trying to retrieve.

Script out the select in its entirety that you use, including schema name.