SELECT CASE
WHEN TABLE_NO = 'A' THEN '93'
WHEN TABLE_NO = 'B' THEN '94'
END AS 'TABLE_NO'
,WORK_NO + ' ' + REPLACE(STR(RB_NO),' ', '') AS 'WORK_NO_RB_NO'
,PIECE_NO AS 'PIECE_NO'
FROM RUNTIME_ITEM
WHERE CUT_YN = 'Y'
ORDER BY TABLE_NO, ITEM_SEQ ASC
이럴땐 오라클이 그립다.
Posted by shiftkey
