nicht angemeldet
Moin Moin !
Wie wäre das:
SELECT
id,COUNT(*) AS n
FROM
tabelle
WHERE
farbe='rot' OR farbe='blau'
GROUP BY
id
HAVING
n > 1 <---- evtl. auch COUNT(*) statt n
Alexander
--
Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so!"
Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so!"