Need some help to build a MySQL request ...

[Xavier COLLET-MATRAT]

Hi,

I need some help to buid a MySQL request :

I've a table buided like this :

field1            field2          field3
1                 23              2
2                 23              12
3                 25              1
4                 25              3
5                 25              85
6                 26              16
7                 27              2
8                 27              12
9                 28              5
10                29              6
...

I need to launch a "select" request to obtain (for exemple) all the values
(field2) associated whith some field3 having at the same time the value 2
and 12. In the exemple the request may return 23 and 27 ...

I don't know if my question is very clear ???!!

Thanks in advance for your answers and excuse me for my VERY VERY VERY bad
english :-))) .

Xavier
xcm@stripped