I’m trying to run an execSQL with a join between two tables, but each one of them is under a different schema. If I don’t refer to the owner (ex.: select * from user.table) it returns an error message: table or view does not exist, and if I refer to the owner I got no data.
Do I need to refer to the owner into the WHERE clause?
Does anyone face this problem before?
IS 4.6 + JDBC Oracle Adapter + Oracle 184.108.40.206.0