I am trying to pull data using the cross query editor. I used the the IntelliSense to fully qualify the table but it doesnt seem to work because the query works fine in the normal editor (without fully qualifying the source) but I get an error saying the sql has been stopped by TDA3.
Below is the FROM clause that is fully qualified using the IntelliSense
Below is how I normally would reference the table
Any suggestions to get this query to work in the cross query editor would be greatly appriciated.