Quick thought, is it possible that the initial code was double pasted? Below is what I would guess it should be.

😎

SELECT

tB.ORDER_DATE

,tB.COMMIT_NO

,tA.PRT_ID

,tA.PRT_POS

,tA.PRT_TITLE

,tA.ITEM_CODE

,ISNULL(tB.ALC_CODE,'') ALC_CODE

,ISNULL(tC.PRINT_SCRIP,'') PRINT_SCRIP

,CASE

WHEN tC.PRINT_SCRIP = '' THEN tB.ALC_CODE

WHEN tC.PRINT_SCRIP <> '' THEN tC.PRINT_SCRIP

ELSE tB.ALC_CODE

END ALC_RESULT

FROM

(

SELECT

*

,CASE

WHEN BODY_NO like 'A6%' THEN 'GDe'

WHEN BODY_NO like 'IT%' THEN 'EL'

WHEN BODY_NO like 'JC%' THEN 'JC'

END CAR_CODE

FROM [dbo].[TB_WORK_ORDERDTL_CPM01]

WHERE ORDER_DATE = '20140825'

AND COMMIT_NO = '0222'

) tB

LEFT JOIN TB_CODE_ALC tC

ON tC.ITEM_CODE = tB.ITEM_CODE

AND tC.CAR_CODE = tB.CAR_CODE

AND tC.ALC_CODE = tB.ALC_CODE

RIGHT JOIN [TB_CODE_PRTFORM] tA

ON tC.CAR_CODE = tA.CAR_CODE

and tA.PRT_ID ='CPM-PRT-01'

AND tC.ITEM_CODE = tA.ITEM_CODE

WHERE ORDER_DATE IS NOT NULL

AND tA.CAR_CODE IN ('EL','JC','GDe')

AND SUBSTRING(PRT_ID,1,3) = SUBSTRING('CPM01',1,3)

AND ( tA.PRT_POS >= 1 AND tA.PRT_POS <= 60 )

AND PRT_ID='CPM-PRT-01'

ORDER BY ORDER_DATE, COMMIT_NO, BODY_NO , ITEM_CODE;