SELECT 
I.ITEM_CODE ASITEM
,I.ITEM_NAME ASI_NAME
,C.CL_NAME AS C_NAME
,S.SIZE_NAME AS S_NAME
FROM
 (SELECT * FROM ITEM WHERE STOCK_MANAGEMENT_TYPE = 1) C
 ,COLOR_TBL C
 ,SIZE_TBL S
ORDBY
 I.ITEM_CODE
 ,C.I.ITEM_CODE
 ,S.SIZE_CODE
 ;