Unable to change table name in query

[gats1527]

We have a current TI process which pulls data from a 1 table with no issues. We are trying to point that query to a new table with the same fields that hold historical data, but when i change the FROM clause of the query to be the new table name, i receive the error message below.

"SQL Statement failed"

I am however successfully able to run that query directly on the SQL server with results.