topic Re: Definition Query not working after join? in Mapping Questions https://community.esri.com/t5/mapping-questions/definition-query-not-working-after-join/m-p/262254#M2786 <HTML><HEAD></HEAD><BODY><P>Thanks for taking the time to reply Abdullah.</P><P></P><P>I too noticed the table name change in the&nbsp;dialog. Unfortunately changing it does not affect the query error&nbsp;behavior.</P><P></P><P><IMG alt="" class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/385591_Capture.PNG" style="height: auto;" />\</P><P>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}.&nbsp;</P><P></P><P>Even very simple queries fail...&nbsp;</P><P><IMG alt="" class="image-2 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/385607_Capture.PNG" style="height: auto;" /></P><P></P><P><IMG alt="" class="image-3 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/385608_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 04 Dec 2017 18:46:19 GMT forestknutsen1 2017-12-04T18:46:19Z Definition Query not working after join? https://community.esri.com/t5/mapping-questions/definition-query-not-working-after-join/m-p/262252#M2784 <HTML><HEAD></HEAD><BODY><P>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&nbsp;with in Oracle 12c.</P><P></P><P>The cut down query...</P><P><SPAN style="color: #008080; font-size: small;">exists</SPAN><SPAN style="color: #000080; font-size: small;"> (</SPAN><SPAN style="color: #008080; font-size: small;">select</SPAN><SPAN style="color: #000080; font-size: small;"> * </SPAN><SPAN style="color: #008080; font-size: small;">from</SPAN><SPAN style="color: #000080; font-size: small;"> ARCFM8.Transformer)</SPAN></P><P></P><P>Working fine before the join....</P><P><IMG alt="" class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/385507_Capture_woring.PNG" style="height: auto;" /></P><P></P><P>Not working after the join....</P><P><IMG alt="" class="image-2 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/385508_Capture_not_woring.PNG" style="height: auto;" /></P><P>Suggestions?</P></BODY></HTML> Sat, 02 Dec 2017 01:34:41 GMT https://community.esri.com/t5/mapping-questions/definition-query-not-working-after-join/m-p/262252#M2784 forestknutsen1 2017-12-02T01:34:41Z Re: Definition Query not working after join? https://community.esri.com/t5/mapping-questions/definition-query-not-working-after-join/m-p/262253#M2785 <HTML><HEAD></HEAD><BODY><P>Check your Query After *FROM statement , because it changed.</P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/385532_pastedImage_1.png" style="width: auto; height: auto;" /></P></BODY></HTML> Sun, 03 Dec 2017 18:39:09 GMT https://community.esri.com/t5/mapping-questions/definition-query-not-working-after-join/m-p/262253#M2785 AbdullahAnter 2017-12-03T18:39:09Z Re: Definition Query not working after join? https://community.esri.com/t5/mapping-questions/definition-query-not-working-after-join/m-p/262254#M2786 <HTML><HEAD></HEAD><BODY><P>Thanks for taking the time to reply Abdullah.</P><P></P><P>I too noticed the table name change in the&nbsp;dialog. Unfortunately changing it does not affect the query error&nbsp;behavior.</P><P></P><P><IMG alt="" class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/385591_Capture.PNG" style="height: auto;" />\</P><P>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}.&nbsp;</P><P></P><P>Even very simple queries fail...&nbsp;</P><P><IMG alt="" class="image-2 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/385607_Capture.PNG" style="height: auto;" /></P><P></P><P><IMG alt="" class="image-3 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/385608_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 04 Dec 2017 18:46:19 GMT https://community.esri.com/t5/mapping-questions/definition-query-not-working-after-join/m-p/262254#M2786 forestknutsen1 2017-12-04T18:46:19Z