Help with SQL statement for make query layer

[JamesJudge]

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

[JoshuaBixby · Accepted solution]

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?

[JamesJudge]

I now understand that we need to setup the linked Oracle DB to create a view with the two databases.