MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE products (
  id INT,
  Sales VARCHAR(100)
);
INSERT INTO products VALUES
  (1, 10), (2, 11), (3, 12);
CREATE TABLE productsUPDATE (
  id INT,
  Sales VARCHAR(100)
);
INSERT INTO productsUPDATE VALUES
  (1, 40), (2, 50), (3, 80);
CREATE VIEW products_current AS
    SELECT p.id, CONCAT_WS(',', GROUP_CONCAT(DISTINCT p.Sales), GROUP_CONCAT(pu.Sales SEPARATOR ',')) 
    FROM products p INNER JOIN productsUPDATE pu ON p.id = pu.id GROUP BY p.id;
SELECT * FROM products_current;


id
Name_exp_2


1
10,40

2
11,50

3
12,80


UPDATE products 
INNER JOIN productsUPDATE ON products.id = productsUPDATE.id 
SET products.sales = CONCAT_WS(',', products.sales, productsUPDATE.sales);
SELECT * FROM products;


id
Sales


1
10,40

2
11,50

3
12,80