Definition Query not working after join?
687
2
12-01-2017 05:34 PM
I have a query that is failing after a join. I have greatly simplified the query to try and pin down the problem. We are using a SDE source with in Oracle 12c.
The cut down query...
exists (select * from ARCFM8.Transformer)
Working fine before the join....
Not working after the join....
Suggestions?
by
Check your Query After *FROM statement , because it changed.
Thanks for taking the time to reply Abdullah.
I too noticed the table name change in the dialog. Unfortunately changing it does not affect the query error behavior.
\
It is also weird because the fully qualified name for the transformer fields should be ARCFM8.Transformer.{field name}. And not ARCFM8.Transformer_Transformer_FM.{field name}.
Even very simple queries fail...
