Tabellenabfrage, Kriterien koppeln

[thomas_w]

So noch eine andere Idee. Geht allerdings nur wegen einem bösen SQL-Foul.

SELECT m.*,
 ( SELECT COUNT(*) FROM members_daten m1 WHERE m1.haarfarbe = 2 AND m1.id = m.id) +
 ( SELECT COUNT(*) FROM members_daten m2 WHERE m2.geschlecht = 2 AND m2.id = m.id) +
 ( SELECT COUNT(*) FROM members_daten m3 WHERE m3.plz BETWEEN 65000 AND 65500 AND m3.id = m.id) AS q1
 FROM members_daten m
HAVING q1 >= 2
ORDER BY q1 DESC;

+----+--------+-----------+-------+------------+------+
| id | name   | haarfarbe | plz   | geschlecht | q1   |
+----+--------+-----------+-------+------------+------+
|  2 | Name-2 |         2 | 66000 |          2 |    2 |
|  4 | Name-4 |         2 | 65000 |          1 |    2 |
+----+--------+-----------+-------+------------+------+
2 rows in set (0.00 sec)

mysql>

Grüße
Thomas