新年好!
BOM展开方面的问题请教高手:
在manuf_structure表中,其主要字段是
PARENT_PART与COMPONENT_PART 当我用下记SQL:
select parent_part,component_part
from manuf_structure
start with parent_part LIKE 'S-%'
connect by parent_part=prior component_part;
其S-系列结果之一是:
我想要的结果如下表,即PARENT_PART列输出的是START_WITH的品番.
怎样的查询语句能达到这样的结果呢?我们公司的BOM展开最多有10多层,很烦啦!
先谢谢了!!
BOM展开方面的问题请教高手:
在manuf_structure表中,其主要字段是
PARENT_PART与COMPONENT_PART 当我用下记SQL:
select parent_part,component_part
from manuf_structure
start with parent_part LIKE 'S-%'
connect by parent_part=prior component_part;
其S-系列结果之一是:
S-A | 1001 |
1001 | 2001 |
1001 | 2002 |
1001 | 2003 |
1001 | 2004 |
2001 | 3001 |
2001 | 3002 |
2002 | 3003 |
2002 | 3004 |
2002 | 3005 |
3003 | 4001 |
4001 | 5001 |
4001 | 5002 |
S-A | 1001 |
S-A | 2001 |
S-A | 2002 |
S-A | 2003 |
S-A | 2004 |
S-A | 3001 |
S-A | 3002 |
S-A | 3003 |
S-A | 3004 |
S-A | 3005 |
S-A | 4001 |
S-A | 5001 |
S-A | 5002 |
先谢谢了!!
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12391917/viewspace-247738/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12391917/viewspace-247738/