I have 2 tables
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.