AnsweredAssumed Answered

Nested SQL

Question asked by Vyke on Dec 31, 2013
Latest reply on Jan 13, 2014 by user19752

I have 2 tables

 

Cart (CartID)

LineItems (CartID, LineItemID, Summary, MaterialID)

 

I am trying to pull only the LineItemID from the LineItems where the summary is a distinct value to use for filtering a portal for duplicates.

 

 

ExecuteSQL(


"SELECT
 I.LineItemsID
FROM
 LineItems AS I
WHERE
 I.LineItemsID IN (SELECT DISTINCT I.c_SumOfValues FROM I WHERE FK_CartID =?)";
"";"";Cart::CartID
)

 

but nothing I try seems to work, I just keep getting "?" Any help would be appreciated.

Outcomes