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%%'