query regarding BOM

[Former Member]

Helllo All,

Is it possible to get a query where i can get to know whether a particular item is used in various bom's?? If any query is available, please help..

thank you all.

Amon

[former_member204969 · Accepted solution]

Try this query:

SELECT T1.[Father], T1.[Code], T1.[Quantity]
 FROM [dbo].[ITT1]  T1
 WHERE T1.[Code] =[%0]