Hello All, This will come across as a Newb question to you, but what i am trying to replicate is the following query in Dynamics Query Object
SELECT Table1.Field1, Table1.Field2, Table2.Field1, Table2.Field2,
FROM Table1 INNER JOIN
Table2 ON Table1.Field1 EQUALS Table2.Field2
AND
Table1.Field2 (DOES NOT EQUAL) Table2.Field2
It is this second part Highlighted above ( Table1.Field2 (DOES NOT EQUAL) Table2.Field2) that i am having issues with.
(Does not Equals) option does not exist in Relations and i have tried using range where in the range i put !=Table2.Field2 but it does not seem to work. How can i go about doing this??
If I created method would i be able to use xx to create a range, I am having a hard time understanding what i need to declare in the method as i am very new to x++. Any Guidance would be appreciated
