Skip to Content
May 18, 2016 at 11:09 AM

Query To Show Component, Sub Assembly and Finished Prouduct


Hi Experts

I have a basic query which returns a component, the stock to that component and the sub assembly code to that component.

What I also need is the report to return the finished product code to the sub assembly. So as per the below t1.father is the sub assembly but this is also a component of a finished product which I need to show?

SELECT T0.[ItemCode], T0.[ItemName], T0.[OnHand], T0.[IsCommited], T0.[OnOrder], T1.[Father] FROM OITM T0 left join ITT1 T1 on t0.itemcode=t1.code WHERE T0.[ItemCode] Like 'pbds%%'

Kind Regards