Skip to Content
Former Member
May 04, 2018 at 08:37 AM

How to use "option (loop join)" in Flexible search query


Hi, I would like to know how to use OPTION(LOOP JOIN) in Flexible search query. We are able to use it in SQL query but unfortunately unable to leverage in Flexible search query. We have applied it in SQL query as shown below:

SELECT FROM orders AS O JOIN orderentries AS OE ON OE.p_order=O.PK OPTION(LOOP JOIN)*

Feel free to let me know if you need any more information.