MySQL Abfrage über 2 Tabellen

postgres=# select * from komponenten ;
 produkt | komponente 
---------+------------
       1 |        123
       1 |        456
       1 |        789
       1 |        134
       1 |        188
       2 |        123
       2 |        456
       2 |        677
       2 |        777
       2 |        223
       2 |        334
       3 |        123
       3 |        456
       3 |        781
       3 |        134
       3 |        333
       3 |        431
(17 rows)

postgres=# select produkt, array_agg(komponente) from komponenten group by produkt having array_agg(komponente) @> array[123,456,134]; ;
 produkt |         array_agg         
---------+---------------------------
       3 | {123,456,781,134,333,431}
       1 | {123,456,789,134,188}
(2 rows)

postgres=#

WITH produkt(id,[name]) AS (
	SELECT 1,'EINS' UNION ALL  
	SELECT 2,'ZWEI' UNION ALL  
	SELECT 3,'DREI'  
	), komponenten(id,id_produkt,nummer) AS (
	SELECT 0,1,123 UNION ALL
	SELECT 1,1,456 UNION ALL
	SELECT 2,1,789 UNION ALL
	SELECT 3,1,134 UNION ALL
	SELECT 4,1,188 UNION ALL
	SELECT 5,2,123 UNION ALL
	SELECT 6,2,456 UNION ALL
	SELECT 7,2,677 UNION ALL
	SELECT 8,2,777 UNION ALL
	SELECT 9,2,223 UNION ALL
	SELECT 10,2,334 UNION ALL
	SELECT 11,3,123 UNION ALL
	SELECT 12,3,456 UNION ALL
	SELECT 13,3,781 UNION ALL
	SELECT 14,3,134 UNION ALL
	SELECT 15,3,333 UNION ALL
	SELECT 16,3,431
	), werteliste(nummer) AS (
	SELECT 123 UNION ALL
	SELECT 456 UNION ALL
	SELECT 134
	)
SELECT	k.id_produkt
FROM	werteliste w
INNER JOIN komponenten k
ON		w.nummer = k.nummer
GROUP BY k.id_produkt
HAVING count(*) = ( SELECT count(*) FROM werteliste )

SELECT P.id
FROM Produkt AS P
WHERE exists (SELECT id FROM Komponenten WHERE id_produkt = P.id AND nummer = '123') AND  
exists (SELECT id FROM Komponenten WHERE id_produkt = P.id AND nummer = '456') AND  
exists (SELECT id FROM Komponenten WHERE id_produkt = P.id AND nummer = '134')  

SELECT DISTINCT P.id
FROM Produkt AS P
join Komponenten as k1 on k1.id_produkt = P.id AND k1.nummer = '123'  
join Komponenten as k2 on k2.id_produkt = P.id AND k2.nummer = '456'  
join Komponenten as k3 on k3.id_produkt = P.id AND k3.nummer = '134'  

postgres=# select produkt, count(komponente) from komponenten where komponente in (123,456,134) group by produkt having count(produkt) = 3;
 produkt | count 
---------+-------
       3 |     3
       1 |     3
(2 rows)