SELECT * FROM tabelle1 AS t1, tabelle2 AS t2, tabelle3 AS t3 WHERE t1.spalte1='trallala' AND t2.spalte1='haumichblau' AND NOT t3.anderespalte='nixda';