Help with SQL statement for make query layer

Question

I'm trying make a query layer using tabular information in an Oracle database and a parcel centriod point file. The SQL query I'm using is not working and the error seems like the oracle table is not being found.

Attached is my SQL statement and error message

BTR Query.docx

Capture.JPG

bixb0012 · Accepted Answer

You are trying to join tables that are not only in different databases, but different DBMSes.  Although doing such a query is possible in the DBMS realm, it requires linked servers to be configured correctly.  Are you sure either the Oracle or SQL Server database is configured correctly to support a database link to the other?