sql statement question

From: Pascal Schmidt-Volkmar (pascalsv_at_nospam_tauth.com)
Date: 01/28/04 

Date: Wed, 28 Jan 2004 10:57:11 +0100

Hi there,

this is an extract of my table (three rows):

KANT_PLATZ | KANT_KRIT_ID | KANT_ANTWORT

1 1
1
1 2
1
1 3
3
1 4
2
2 1
1
2 2
1
2 3
1
2 4
3

Now I would like to gather those datasets, where KANT_ANTWORT for
KANT_KRIT_ID 1 is 1 and where KANT_ANTWORT for KANT_KRIT_ID 2 is 1.

Using:

SELECT KANT_PLATZ FROM T_KANT WHERE
                ((KANT_KRIT_ID = 1 AND KANT_ANTWORT = 1) AND
                (KANT_KRIT_ID = 2 AND KANT_ANTWORT = 1))

shows no datsasets although both KANT_PLATZ 1 & 2 fit to this statement.
What am I doing wrong??

Thanks a lot, I am stuck!

Pascal