Compte (*) de différentes tables sous condition - MYSQL

Tant que vous voulez les mêmes informations des deux tableaux, vous pouvez utiliser

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)

PRODUCT_ID | CountA | PRODUCT_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

db <> violon ici