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;