22,300
社区成员




M 5021-002-09-75 9E53-16B975-AG31T3 010 2022-120-01
M 5021-002-09-75 9E53-16B975-AG31T3 010 4043-845-01
M 5021-002-09-75 9E53-16B975-AG31T3 020 03FD-980-00
M 5021-002-09-75 9E53-16B975-AG31T3 020 04FD-560-00
M 5021-002-09-75 9E53-16B975-AG31T3 020 1140-MTP-00
M 5021-002-09-75 9E53-16B975-AG31T3 020 1711-101-04
M 5021-002-09-75 9E53-16B975-AG31T3 020 1713-080-04
M 5021-002-09-75 9E53-16B975-AG31T3 020 1952-723-02
M 5021-002-09-75 9E53-16B975-AG31T3 020 2811-042-05
M 5021-002-09-75 9E53-16B975-AG31T3 020 4043-620-01
M 5021-002-09-75 9E53-16B975-AG31T3 020 4072-875-02
M 5021-002-09-75 9E53-16B975-AG31T3 020 4072-891-01
M 5021-002-09-75 9E53-16B975-AG31T3 020 5601-371-03
MP65K100
WorkOrderNo StockCode OperationNo Component ParentItem
0004109583 5021-002-09-75 010 0SAE-925-00 4043-844-01
0004109583 5021-002-09-75 010 HSML-002-00 4043-845-01
0004109583 5021-002-09-75 010 PA66-A3Z-00 4043-845-01
0004109583 5021-002-09-75 010 2022-120-01 5021-002-09-75
0004109583 5021-002-09-75 010 HSAE-925-00 4043-620-01A
0004109583 5021-002-09-75 000 BASF-POM-00 4072-875-02
0004109583 5021-002-09-75 000 HSML-002-00 4072-875-02
0004109583 5021-002-09-75 010 BASF-POM-00 4072-891-01
0004109583 5021-002-09-75 010 HSML-002-00 4072-891-01
0004109583 5021-002-09-75 020 03FD-980-00 5021-002-09-75
0004109583 5021-002-09-75 020 04FD-560-00 5021-002-09-75
0004109583 5021-002-09-75 020 1140-MTP-00 5021-002-09-75
0004109583 5021-002-09-75 020 1711-101-04 5021-002-09-75
0004109583 5021-002-09-75 020 1713-080-04 5021-002-09-75
0004109583 5021-002-09-75 020 1952-723-02 5021-002-09-75
0004109583 5021-002-09-75 020 2811-042-05 5021-002-09-75
0004109583 5021-002-09-75 020 5601-371-03 5021-002-09-75
WorkOrderNo StockCode OperationNo1 Discraption Component
0004109583 5021-002-09-75 020 HSAE-925-00 4043-620-01A
0004109583 5021-002-09-75 020 BASF-POM-00 4072-875-02
0004109583 5021-002-09-75 020 HSML-002-00 4072-875-02
0004109583 5021-002-09-75 020 BASF-POM-00 4072-891-01
0004109583 5021-002-09-75 020 HSML-002-00 4072-891-01
0004109583 5021-002-09-75 020 03FD-980-00 5021-002-09-75
0004109583 5021-002-09-75 020 04FD-560-00 5021-002-09-75
0004109583 5021-002-09-75 020 1140-MTP-00 5021-002-09-75
0004109583 5021-002-09-75 020 1711-101-04 5021-002-09-75
0004109583 5021-002-09-75 020 1713-080-04 5021-002-09-75
0004109583 5021-002-09-75 020 1952-723-02 5021-002-09-75
0004109583 5021-002-09-75 020 2811-042-05 5021-002-09-75
0004109583 5021-002-09-75 020 5601-371-03 5021-002-09-75
declare @s nvarchar(50)
set @s='0SAE-925-00'
;with f as
(select * from [MP65K100] a
where [Component]=@s
union all
select a.*
from [MP65K100] a, f b
where a.[StockCode]=b.[ParentItem])
select * from f
结果如下:
BOMTYPE StockCode OperationNo1 Discraption Component
0004109583 5021-002-09-75 020 HSAE-925-00 4043-620-01A
0004109583 5021-002-09-75 020 BASF-POM-00 4072-875-02
0004109583 5021-002-09-75 020 HSML-002-00 4072-875-02
0004109583 5021-002-09-75 020 BASF-POM-00 4072-891-01
0004109583 5021-002-09-75 020 HSML-002-00 4072-891-01
0004109583 5021-002-09-75 020 03FD-980-00 5021-002-09-75
0004109583 5021-002-09-75 020 04FD-560-00 5021-002-09-75
0004109583 5021-002-09-75 020 1140-MTP-00 5021-002-09-75
0004109583 5021-002-09-75 020 1711-101-04 5021-002-09-75
0004109583 5021-002-09-75 020 1713-080-04 5021-002-09-75
0004109583 5021-002-09-75 020 1952-723-02 5021-002-09-75
0004109583 5021-002-09-75 020 2811-042-05 5021-002-09-75
0004109583 5021-002-09-75 020 5601-371-03 5021-002-09-75
MP65K100
WorkOrderNo StockCode OperationNo Component ParentItem
0004109583 5021-002-09-75 010 0SAE-925-00 4043-844-01
0004109583 5021-002-09-75 010 HSML-002-00 4043-845-01
0004109583 5021-002-09-75 010 PA66-A3Z-00 4043-845-01
0004109583 5021-002-09-75 010 2022-120-01 5021-002-09-75
0004109583 5021-002-09-75 010 HSAE-925-00 4043-620-01A
0004109583 5021-002-09-75 000 BASF-POM-00 4072-875-02
0004109583 5021-002-09-75 000 HSML-002-00 4072-875-02
0004109583 5021-002-09-75 010 BASF-POM-00 4072-891-01
0004109583 5021-002-09-75 010 HSML-002-00 4072-891-01
0004109583 5021-002-09-75 020 03FD-980-00 5021-002-09-75
0004109583 5021-002-09-75 020 04FD-560-00 5021-002-09-75
0004109583 5021-002-09-75 020 1140-MTP-00 5021-002-09-75
0004109583 5021-002-09-75 020 1711-101-04 5021-002-09-75
0004109583 5021-002-09-75 020 1713-080-04 5021-002-09-75
0004109583 5021-002-09-75 020 1952-723-02 5021-002-09-75
0004109583 5021-002-09-75 020 2811-042-05 5021-002-09-75
0004109583 5021-002-09-75 020 5601-371-03 5021-002-09-75
MP61K100
BOMTYPE StockCode Discraption OperationNo1 Component
M 5021-002-09-75 9E53-16B975-AG31T3 010 2022-120-01
M 5021-002-09-75 9E53-16B975-AG31T3 010 4043-845-01
M 5021-002-09-75 9E53-16B975-AG31T3 020 03FD-980-00
M 5021-002-09-75 9E53-16B975-AG31T3 020 04FD-560-00
M 5021-002-09-75 9E53-16B975-AG31T3 020 1140-MTP-00
M 5021-002-09-75 9E53-16B975-AG31T3 020 1711-101-04
M 5021-002-09-75 9E53-16B975-AG31T3 020 1713-080-04
M 5021-002-09-75 9E53-16B975-AG31T3 020 1952-723-02
M 5021-002-09-75 9E53-16B975-AG31T3 020 2811-042-05
M 5021-002-09-75 9E53-16B975-AG31T3 020 4043-620-01
M 5021-002-09-75 9E53-16B975-AG31T3 020 4072-875-02
M 5021-002-09-75 9E53-16B975-AG31T3 020 4072-891-01
M 5021-002-09-75 9E53-16B975-AG31T3 020 5601-371-03
M 4072-891-01 conduit end-fitting 010 BASF-POM-00
M 4072-891-01 conduit end-fitting 010 HSML-002-00
M 4072-875-02 CONDUIT END FITTING 000 BASF-POM-00
M 4072-875-02 CONDUIT END FITTING 000 HSML-002-00
M 4043-620-01A SLUG SPHERICA-BALL 锌接头 010 HSAE-925-00
M 4043-844-01 锌接头 010 0SAE-925-00
M 4043-845-01 锌接头 010 4043-844-01
M 4043-845-01 锌接头 010 HSML-002-00
M 4043-845-01 锌接头 010 PA66-A3Z-00
O 4043-601-01 锌接头 010 4043-601-01A