SELECT 
    ITEM.ITEM_CODE AS ITEM, 
    ITEM.ITEM_NAME AS I_NAME, 
    COLOR_TBL.CL_NAME AS C_NAME, 
    SIZE_TBL.SIZE_NAME AS S_NAME
FROM 
    ITEM
INNER JOIN 
    COLOR_TBL
INNER JOIN 
    SIZE_TBL
ON 
    ITEM.STOCK_MANAGEMENT_TYPE = 1
ORDER BY 
    ITEM.ITEM_CODE ASC, 
    COLOR_TBL.CL_CODE ASC, 
    SIZE_TBL.SIZE_CODE ASC;