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.