SELECT
    a.Parent_ItemBOM, a.Child_ItemChildNo,
    b.WorkCenter, b.OperationNo, b.OperationDesc
FROM
    @T_BOM a
LEFT JOIN
    ROUTING b ON a.Parent_ItemBOM = b.itemno
WHERE
    a.parent_itembom IN (SELECT itemno FROM routing)
ORDER BY
    b.operationno

RK2/7350/7357-4.40-850/XX69/7303FFB R7350/7357-4.40-850       |  8050   |50.000000| COGPAD RCVS
RK2/7350/7357-4.40-850/XX69/7303FFB FXX69/7303FFB-1245        |  8050   |50.000000| COGPAD RCVS
P-ARRGY5704-9.3-850-RE5 F3W/7303FFB-1250                      |  8060   |60.000000| BUILDING RCVS
P-ARRGY5704-9.3-850-RE5 R7350/7357-1.40-850                   |  8060   |60.000000| BUILDING RCVS
P-ARRGY5704-9.3-850-RE5 E1020                                 |  8060   |60.000000| BUILDING RCVS
P-ARRGY5704-9.3-850-RE5 RK2/7350/7357-4.40-850/XX69/7303FFB   |  8060   |60.000000| BUILDING RCVS
SL-ARRGY5704-18.2X9.3X31X842+N  P-ARRGY5704-9.3-850-RE5       |  8070   |70.000000| CURING RCVS
ARRGY5704-18.2X9.3X31X842+N#    SL-ARRGY5704-18.2X9.3X31X842+N|  8080   |80.000000| CUTTING RCVS
ARRGY5704-18.2X9.3X31X842+N#    SL-ARRGY5704-18.2X9.3X31X842+N|  8081   |81.000000| SANDING
ARRGY5704-18.2X9.3X31X842+N#    SL-ARRGY5704-18.2X9.3X31X842+N|  8082   |82.000000| POC RCVS
ARRGY5704-18.2X9.3X31X842+N#    SL-ARRGY5704-18.2X9.3X31X842+N|  8090   |90.000000| INSPECTION RCVS