Skip to Content
0
Nov 29, 2014 at 09:42 AM

Item list where there is no sell

24 Views

Hi,

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

FROM OITM

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.

Rgds

Suman