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