select
    ITEM.ITEM_CODE as ITEM,
    ITEM_NAME as I_NAME,
    CL_NAME as C_NAME,
    SIZE_NAME as S_NAME
from
    ITEM
    left join SIZE_TBL
    left join COLOR_TBL
order by
    ITEM.ITEM_CODE,
    CL_CODE,
    SIZE_CODE