Query

[Former Member]

Hi

I am using Moving Average method . I want list of items whose item cost has not been defined.

Thanks

[Former Member]

Closed.

[Former Member]

Hi RS.........

Check this out...........

Select T0.ItemCode, T1.ItemName, T0.AvgPrice From OITW T0 Inner Join OITM T1 
On T0.ItemCode=T1.ItemCode
Where T0.AvgPrice is Null.........

Regards,

Rahul

[Former Member]

Try:

SELECT ItemCode, ItemName FROM dbo.OITM

WHERE AvgPrice = 0 AND InvntItem='Y'

Thanks,

Gordon