請參考如下:
SELECT * FROM
(SELECT P.SITE,I.ITEM, SFC.SFC,SO.BATCH_NUMBER
,SO.SHOP_ORDER
,O.OPERATION, OT.DESCRIPTION AS OP_DESC
,SRRS.STEP_ID
,PM.DESCRIPTION AS MEA_DESC
,PM.ACTUAL
,PM.TEST_DATE_TIME
,P.ROUTER_BO
,PM.MEASURE_NAME
,PM.MEASURE_GROUP
,PM.MEASURE_STATUS
,PM.DC_PARAMETER_BO
,DCP.PARAMETER_NAME
,DCP.DATA_FIELD_BO