MariaDB 10.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE products (
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
barcode INT,
product_name VARCHAR(255),
product_size VARCHAR(255),
product_price DECIMAL(10,2));

INSERT INTO products (barcode, product_name, product_size, product_price) VALUES
(111,'product_1','1KG',11),
(222,'product_2','2KG',12),
(333,'product_3','3KG',13);

CREATE TABLE sales_tbl202201 (
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
barcode INT,
sales_date DATE,
sales_receipt VARCHAR(255),
sold_qty DECIMAL(10,2),
sales_amt DECIMAL(10,2));

INSERT INTO sales_tbl202201(barcode, sales_date, sales_receipt, sold_qty, sales_amt) VALUES
(111, '2022-01-05', 'rct22010501', 5, 55),
(222, '2022-01-07', 'rct22010701', 3, 36),
(111, '2022-01-15', 'rct22011501', 2, 22),
(222, '2022-01-15', 'rct22011501', 1, 12),
(333, '2022-01-15', 'rct22011501', 1, 13),
(111, '2022-01-15', 'rct22012502', 4, 44);

CREATE TABLE sales_tbl202202 (
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
barcode INT,
sales_date DATE,
sales_receipt VARCHAR(255),
sold_qty DECIMAL(10,2),
sales_amt DECIMAL(10,2));

INSERT INTO sales_tbl202202(barcode, sales_date, sales_receipt, sold_qty, sales_amt) VALUES
(111, '2022-02-25', 'rct22022501', 5, 55),
(222, '2022-02-27', 'rct22022701', 3, 36),
(111, '2022-02-28', 'rct22022801', 2, 22);

CREATE TABLE sales_tbl202203 (
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
barcode INT,
sales_date DATE,
sales_receipt VARCHAR(255),
sold_qty DECIMAL(10,2),
sales_amt DECIMAL(10,2));

INSERT INTO sales_tbl202203(barcode, sales_date, sales_receipt, sold_qty, sales_amt) VALUES
(222, '2022-03-11', 'rct22011101', 1, 12),
(333, '2022-03-16', 'rct22011601', 1, 13),
(111, '2022-03-19', 'rct22011901', 4, 44);
SET @columns := NULL;
SET @sql := NULL;
SET @df := '2022-01-07';
SET @dt := CURDATE();
SET @pc := 'barcode IN ("111", "222", "333")';

SELECT  GROUP_CONCAT(
        CASE WHEN seq=1 THEN
        CONCAT('SUM(CASE WHEN barcode="',barcode,'" then sold_qty else 0 END) AS "',
        product_name,' \r\n ---- \r\n Sold Qty"')
              WHEN seq=2 THEN
        CONCAT('SUM(CASE WHEN barcode="',barcode,'" then sales_amt else 0 END) AS "',
        product_name,'  \r\n ---- \r\n Sales Amt"') END SEPARATOR ', \r\n' ) INTO @columns
FROM products
CROSS JOIN (SELECT 1 seq UNION SELECT 2) s
WHERE barcode IN ("111", "222", "333");

SELECT CONCAT('SELECT sales_date,
',@columns,' 
FROM (',
       GROUP_CONCAT(
       CONCAT(
       '
       SELECT * FROM ',TABLE_NAME,' WHERE ',@pc) SEPARATOR ' \r\n UNION ALL \r\n'),
       ') v 
  WHERE sales_date >= "',@df,'"
  AND sales_date < "',@dt,'"
  GROUP BY sales_date;') into @sql
FROM information_schema.tables
WHERE table_name LIKE 'sales_tbl%'
  AND STR_TO_DATE(CONCAT(RIGHT(TABLE_NAME,6),'01'),'%Y%m%d') >= @df-INTERVAL 1 MONTH; 
  
  SELECT @sql;


@sql


SELECT sales_date,
SUM(CASE WHEN barcode="111" then sold_qty else 0 END) AS "product_1 
 ---- 
 Sold Qty", 
SUM(CASE WHEN barcode="111" then sales_amt else 0 END) AS "product_1  
 ---- 
 Sales Amt", 
SUM(CASE WHEN barcode="222" then sold_qty else 0 END) AS "product_2 
 ---- 
 Sold Qty", 
SUM(CASE WHEN barcode="222" then sales_amt else 0 END) AS "product_2  
 ---- 
 Sales Amt", 
SUM(CASE WHEN barcode="333" then sold_qty else 0 END) AS "product_3 
 ---- 
 Sold Qty", 
SUM(CASE WHEN barcode="333" then sales_amt else 0 END) AS "product_3  
 ---- 
 Sales Amt" 
FROM (
       SELECT * FROM sales_tbl202201 WHERE barcode IN ("111", "222", "333") 
 UNION ALL 

       SELECT * FROM sales_tbl202202 WHERE barcode IN ("111", "222", "333") 
 UNION ALL 

       SELECT * FROM sales_tbl202203 WHERE barcode IN ("111", "222", "333")) v 
  WHERE sales_date >= "2022-01-07"
  AND sales_date < "2022-03-15"
  GROUP BY sales_date;


PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;


sales_date
product_1 
 ---- 
 Sold Qty
product_1  
 ---- 
 Sales Amt
product_2 
 ---- 
 Sold Qty
product_2  
 ---- 
 Sales Amt
product_3 
 ---- 
 Sold Qty
product_3  
 ---- 
 Sales Amt


2022-01-07
0.00
0.00
3.00
36.00
0.00
0.00

2022-01-15
6.00
66.00
1.00
12.00
1.00
13.00

2022-02-25
5.00
55.00
0.00
0.00
0.00
0.00

2022-02-27
0.00
0.00
3.00
36.00
0.00
0.00

2022-02-28
2.00
22.00
0.00
0.00
0.00
0.00

2022-03-11
0.00
0.00
1.00
12.00
0.00
0.00
sales_date	product_1 ---- Sold Qty	product_1 ---- Sales Amt	product_2 ---- Sold Qty	product_2 ---- Sales Amt	product_3 ---- Sold Qty	product_3 ---- Sales Amt
2022-01-07	0.00	0.00	3.00	36.00	0.00	0.00
2022-01-15	6.00	66.00	1.00	12.00	1.00	13.00
2022-02-25	5.00	55.00	0.00	0.00	0.00	0.00
2022-02-27	0.00	0.00	3.00	36.00	0.00	0.00
2022-02-28	2.00	22.00	0.00	0.00	0.00	0.00
2022-03-11	0.00	0.00	1.00	12.00	0.00	0.00