SELECT 
    ITEM_CODE AS ITEM,
    ITEM_NAME AS I_NAME,
    ct.CL_NAME AS C_NAME,
    st.SIZE_nAME AS S_NAME
FROM ITEM as itm
LEFT JOIN COLOR_TBL AS ct
LEFT JOIN SIZE_TBL AS st
WHERE itm.STOCK_MANAGEMENT_TYPE = 1
ORDER BY 
    ITEM_CODE ASC,
    CL_CODE ASC,
    SIZE_CODE ASC