MySQL 5.7

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

CREATE TABLE TableA (PRoDUKT_ID varchar(10))
INSERT INTO TableA VALUES ("1AHO"),("1ADS"),("1ADS")
CREATE TABLE TableB (ProDUKT_ID varchar(10))
INSERT INTO TableB VALUES ("1AHO"),("1AHO"),("1ADS"),("1ADS")
SELECT a.ProDUKT_ID, CountA, b.ProDUKT_ID,CountB
FROM
(SELECT ProDUKT_ID,COUNT(*) CountA FROM TableA WHERe PRoDUKT_ID = "1AHO") a INNER JOIN
(SELECT ProDUKT_ID,COUNT(*) CountB FROM TableB WHERe PRoDUKT_ID = "1AHO") b USING (ProDUKT_ID)


ProDUKT_ID
CountA
ProDUKT_ID
CountB


1AHO
1
1AHO
2


SELECT a.ProDUKT_ID, CountA, b.ProDUKT_ID,CountB
FROM
(SELECT ProDUKT_ID,COUNT(*) CountA FROM TableA GROUP BY ProDUKT_ID) a INNER JOIN
(SELECT ProDUKT_ID,COUNT(*) CountB FROM TableB GROUP BY ProDUKT_ID) b USING (ProDUKT_ID)


ProDUKT_ID
CountA
ProDUKT_ID
CountB


1ADS
2
1ADS
2

1AHO
1
1AHO
2