Skip to Content
0
Jul 22, 2010 at 06:47 AM

Help on query

12 Views

Hello

I would like to have some elp

I want through a query to check all item lines on a sales documents with OITM table but the synthax I use gives me only the first line and first item code, please tell me what is the synthax to check several lines of a sales document

Thank you

SELECT T0.[ItemCode] FROM OITM T0 WHERE T0.[frozenFor] ='Y' and (T0.[ItemCode]=$[$38.1.0.0] or T0.[ItemCode]=$[$38.1.0.1] OR T0.[ItemCode]=$[$38.1.0.2] OR T0.[ItemCode]=$[$38.1.0.3] OR T0.[ItemCode]=$[$38.1.0.4] OR T0.[ItemCode]=$[$38.1.0.5] OR T0.[ItemCode]=$[$38.1.0.6] OR T0.[ItemCode]=$[$38.1.0.7] OR T0.[ItemCode]=$[$38.1.0.8] OR T0.[ItemCode]=$[$38.1.0.9])