SELECT OrderID FROM Orders ; WHERE (vp_ItemID < 0 AND Orders.OrderID NOT IN ; (SELECT OrderID FROM LineItems ; WHERE LineItems.ItemID = ABS(?vp_ItemID))) ; OR ; (vp_ItemID >= 0 AND Orders.OrderID IN ; (SELECT OrderID FROM LineItems ; WHERE LineItems.ItemID = ?vp_ItemID))>I have a query where the view parameter is used to generate a subquery:
>SELECT OrderID FROM Orders ; > WHERE Orders.OrderID IN ; > (SELECT OrderID FROM LineItems ; > WHERE LineItems.ItemID = ?vp_ItemID) >>
>SELECT OrderID FROM Orders ; > WHERE IIF(vp_ItemID < 0, ; > Orders.OrderID NOT IN ; > (SELECT OrderID FROM LineItems ; > WHERE LineItems.ItemID = ABS(?vp_ItemID)), ; > Orders.OrderID IN ; > (SELECT OrderID FROM LineItems ; > WHERE LineItems.ItemID = ?vp_ItemID) ) >