>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
Boris,
Try this
SELECT Employer ;
From Employer ;
WHERE Sel_field IN ("english", "french") ;
GROUP BY EMployer ;
HAVING COUNT(*) > 1
--sb--