I am trying to do a Query Selection By Formula that links two tables by the filed ItemNum with the condition that the value of a field in the first table does not equal a value in the second table.
When I look at the ResultPlan there is a Join on the Price fields even when I used the # comparison. How do I define a comparison vs a join ? C_TEXT($vResultPlan;$vResultPath) DESCRIBE QUERY EXECUTION(True) //analysis mode Query Selection by Formula([ItemDiscounts];\ ( ([ItemDiscounts]ItemNum=[Items]ItemNum) \ & ([ItemDiscounts]BasePrice#[Items]PriceB) \ & ([Items]PriceA#0))) $vResultPlan:=Get last query plan(Description in text format) ConsoleMessage("vResultPlan\r"+$vResultPlan) $vResultPath:=Get last query path(Description in text format) ConsoleMessage("vResultPath\r"+$vResultPath) DESCRIBE QUERY EXECUTION(False) //End of analysis mode vResultPlan Join on Table : Items : ItemDiscounts.ItemNum = Items.ItemNum & ItemDiscounts.BasePrice = Items.PriceB Items.PriceA != 0 vResultPath Join on Table : Items : ItemDiscounts.ItemNum = Items.ItemNum & ItemDiscounts.BasePrice = Items.PriceB Items.PriceA != 0 (3247 records found in 4 ms) --> 4030 records found in 22 ms ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************