topic Help with SQL statement for make query layer in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/help-with-sql-statement-for-make-query-layer/m-p/777307#M1414 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Attached is my SQL statement and error message</P></BODY></HTML> Tue, 22 Jan 2019 21:23:19 GMT JamesJudge 2019-01-22T21:23:19Z Help with SQL statement for make query layer https://community.esri.com/t5/geodatabase-questions/help-with-sql-statement-for-make-query-layer/m-p/777307#M1414 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Attached is my SQL statement and error message</P></BODY></HTML> Tue, 22 Jan 2019 21:23:19 GMT https://community.esri.com/t5/geodatabase-questions/help-with-sql-statement-for-make-query-layer/m-p/777307#M1414 JamesJudge 2019-01-22T21:23:19Z Re: Help with SQL statement for make query layer https://community.esri.com/t5/geodatabase-questions/help-with-sql-statement-for-make-query-layer/m-p/777308#M1415 <HTML><HEAD></HEAD><BODY><P>You are trying to join tables that are not only in different databases, but different DBMSes.&nbsp; Although doing such a query is possible in the DBMS realm, it requires linked servers to be configured correctly.&nbsp; Are you sure either the Oracle or SQL Server database is configured correctly to support a database link to the other?</P></BODY></HTML> Tue, 22 Jan 2019 22:02:05 GMT https://community.esri.com/t5/geodatabase-questions/help-with-sql-statement-for-make-query-layer/m-p/777308#M1415 JoshuaBixby 2019-01-22T22:02:05Z Re: Help with SQL statement for make query layer https://community.esri.com/t5/geodatabase-questions/help-with-sql-statement-for-make-query-layer/m-p/777309#M1416 <HTML><HEAD></HEAD><BODY><P>I now understand that we need to setup the linked Oracle DB to create a view with the two databases.</P></BODY></HTML> Wed, 23 Jan 2019 19:27:46 GMT https://community.esri.com/t5/geodatabase-questions/help-with-sql-statement-for-make-query-layer/m-p/777309#M1416 JamesJudge 2019-01-23T19:27:46Z