SELECT
    item_code AS ITEM,
    item_name AS I_NAME,
    cl_name AS C_NAME,
    size_name AS S_NAME
FROM
    item AS i
INNER JOIN
    color_tbl AS c
INNER JOIN
    size_tbl AS s
WHERE
    i.stock_management_type = 1
ORDER BY
    item_code ASC,
    cl_code ASC,
    size_code ASC;