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;