How can I apply query for criteria?
583087Aug 29 2007 — edited Aug 29 2007Please consider this table given below:-
CODE PLACE
A P1
A P2
B P1
C P2
D P1
D P2
Now I just want to retreive code which is only associating with place P1. I expect the result here to be B only.
How can I apply query here?