>Here ot os my problemm:
>
>I have one table which contains some data of the employers. In one field there can be many values. The question is how can I select these employers who correspond to many citeria.
>
>Example:
>
>Table structure:
>Employer C(10)
>Sel_Field C(20)
>
>Table conains:
>
>employer Sel_Field
>george english
>george french
>john chinese
>john french
>
>
>How can I select theese employers which know english & french
>
>the result has to be george but I always get a empty cursor
>
>TIA
>
>Boris

Mr. Berezniker's query should work. You could also try this and see which is faster: SELECT yourtable1.employer FROM yourtable INNER JOIN yourtable AS yourtable1 ON yourtable.employer = yourtable1.employer WHERE yourtable.Sel_field = "english" AND yourtable1.Sel_field = "french"