I need a simple query to get the item list which has stock but no sell during a period.
My query is like this
SELECT ItemCode, ItemName, OnHand
WHERE OnHand >0 and ItemCode not in(
SELECT distinct T0.[ItemCode] FROM OINM T0 WHERE T0.[DocDate] >=[%0] and T0.[DocDate] <=[%1])
The query is not parsing, what could be the reason.