SELECT
t1.ITEM_ID AS "materialCode",
NVL(t1.ITEM_NAME,'') AS "materialName",
NVL(t1.SPEC,'') AS "materialDiscription",
t1.ACCIDENT_TYPE AS "bAccidentPartFlag",
t1.REC_CREATE_TIME AS "aCreateDate",
t1.REC_CREATOR AS "aCreateMan",
t2.PRICE AS "newPrice",
t3.TXT AS "numUnit",
t1.REC_REVISE_TIME AS "aModifyDate"
FROM
WS1W.TWSSB01 t1
LEFT JOIN
WS1W.TWSSB27 t2
ON
t1.ITEM_ID=t2.ITEM_CODE
LEFT JOIN
WS1W.TWSSB21 t3
ON
t2.UNIT_ID=t3.UNIT_ID
WHERE
1=1
ORDER BY
ITEM_ID
FETCH
FIRST 100 rows only