SELECT feld 1 FROM tabelle1 WHERE (feld2, feld3, feld4) IN (SELECT felda, feldb, feldc FROM tabelle2 WHERE ...)