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) AS I
 ,COLOR_TBL AS C
 ,SIZE_TBL AS S
ORDER BY
 I.ITEM_CODE
 ,C.CL_CODE
 ,S.SIZE_CODE
 ;