MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `shj637` (
`ID` int NOT NULL AUTO_INCREMENT, 
`ProductID` VARCHAR(50),
`Name` text, 
`ProductGroup` VARCHAR(50),
PRIMARY KEY(ID)) ;

INSERT INTO `shj637`(`ProductID`,`Name`,`ProductGroup`)
VALUES
('shj637','A','Q1'),
('shj637','A','Q2'),
('shj637','A','Q4');

CREATE TABLE `jsfh748` (
`ID` int NOT NULL AUTO_INCREMENT, 
`ProductID` VARCHAR(50),
`Name` text, 
`ProductGroup` VARCHAR(50),
PRIMARY KEY(ID)) ;

INSERT INTO `jsfh748`(`ProductID`,`Name`,`ProductGroup`)
VALUES
('jsfh748','A','Q1'),
('jsfh748','A','Q2'),
('jsfh748','A','Q4');

CREATE TABLE `hasd548` (
`ID` int NOT NULL AUTO_INCREMENT, 
`ProductID` VARCHAR(50),
`Name` text, 
`ProductGroup` VARCHAR(50),
PRIMARY KEY(ID)) ;

INSERT INTO `hasd548`(`ProductID`,`Name`,`ProductGroup`)
VALUES
('hasd548','A','Q1'),
('hasd548','A','Q2'),
('hasd548','A','Q4');

CREATE TABLE `ProductInfo` (
`ID` int(11) DEFAULT NULL, 
`Question` text, 
`Product Answer` double DEFAULT NULL, 
`Product Score/Mark` double DEFAULT NULL, 
`Feedback` text, 
`ProductID` text, 
`database ID` text) ;
SET @sql := NULL;

SET @sql := (SELECT GROUP_CONCAT(
           CONCAT('SELECT ID, ProductID, Name, ProductGroup FROM ',table_name) 
           SEPARATOR ' UNION ALL ') FROM information_schema.tables
WHERE table_schema=(SELECT table_schema FROM information_schema.tables 
WHERE table_name='jsfh748' GROUP BY table_schema) AND table_name <> 'ProductInfo');

/*Checking @sql variable assignment*/
SELECT @sql;

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


@sql


SELECT ID, ProductID, Name, ProductGroup FROM hasd548 UNION ALL SELECT ID, ProductID, Name, ProductGroup FROM jsfh748 UNION ALL SELECT ID, ProductID, Name, ProductGroup FROM shj637




ID
ProductID
Name
ProductGroup


1
hasd548
A
Q1

2
hasd548
A
Q2

3
hasd548
A
Q4

1
jsfh748
A
Q1

2
jsfh748
A
Q2

3
jsfh748
A
Q4

1
shj637
A
Q1

2
shj637
A
Q2

3
shj637
A
Q4


SELECT ID, ProductID, Name, ProductGroup FROM hasd548 
UNION ALL 
SELECT ID, ProductID, Name, ProductGroup FROM jsfh748 
UNION ALL 
SELECT ID, ProductID, Name, ProductGroup FROM shj637


ID
ProductID
Name
ProductGroup


1
hasd548
A
Q1

2
hasd548
A
Q2

3
hasd548
A
Q4

1
jsfh748
A
Q1

2
jsfh748
A
Q2

3
jsfh748
A
Q4

1
shj637
A
Q1

2
shj637
A
Q2

3
shj637
A
Q4
ID	ProductID	Name	ProductGroup
1	hasd548	A	Q1
2	hasd548	A	Q2
3	hasd548	A	Q4
1	jsfh748	A	Q1
2	jsfh748	A	Q2
3	jsfh748	A	Q4
1	shj637	A	Q1
2	shj637	A	Q2
3	shj637	A	Q4