Skip to Content
0
Sep 01, 2008 at 01:22 PM

Query for BOM

207 Views

I need a query which displays for an spicific BOM child item

all its parent items, for example the Table ITT1 consists of following rows

child_item parent_item

-


I1 P1

I1 P2

P1 P3

P2 P4

I1

the result query should display

child_item parent_item1 parent_item2 parent_item3

-


I1 P1 P3

I1 P2 P4