SELECT
 ITEM.ITEM_CODE ITEM
,ITEM.ITEM_NAME I_NAME
,COLOR_TBL.CL_NAME C_NAME
,SIZE_TBL.SIZE_NAME S_NAME
FROM ITEM,COLOR_TBL, SIZE_TBL
WHERE ITEM.STOCK_MANAGEMENT_TYPE = 1
ORDER BY
 ITEM.ITEM_CODE
,COLOR_TBL.CL_CODE
,SIZE_TBL.SIZE_CODE
;