Not(not in ()) ? how ?

[namida]

My logic is all mixed up

I have a table for language choice


login* prefno* lang_spo
1 1 English
1 2 Chinese
1 3 French
2 1 English
2 2
2 3

Login and prefno are primary keys

The pref no means the preference order. which means login 1 is probably most proficient in English

Login 2 can only speak English but a slot is always always allocated "empty" (this doesn't actually matter)

What I Want is to find who can speak English AND chinese AND French

how do I do that?

if I use IN('English','Chinese','French') It chooses 1 and 2 (since it's anything that matches the IN params )while I just want login 1 to be displayed?

Regards,

Namida

 

[swampBoogie]

select login from t
where lang_spo in ('English','Chinese','French')
group by login
having count(*) = 3

 

[namida]

Brilliant! Thanks!

Regards,

Namida