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