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