select item.item_code AS ITEM,item.item_name AS I_NAME,color_tbl.cl_name AS C_NAME,size_tbl.size_name AS S_NAME 
    FROM item CROSS JOIN color_tbl CROSS JOIN size_tbl WHERE item.stock_management_type=1 
    ORDER BY item.item_code,color_tbl.cl_code,size_tbl.size_code;