Simple query/ table design question

Hi all,

I have this question about querying a table which lists people with languages they speak

eg
The table language

ind - lan

A  -  english
A  -   french
A  -  german
A  -   italian
B  -   english
B  -  french

C  - norwegain
D  -   french
D  -   chinese

How am i going to query this table to find out who speaks english and french ?
The answer should be A, B and D

if I run the following query :
select distinct ind from language where lan='english' and lan='french', it doesn't work.
Does anyone have any idea what should be done here ?

Thanks all. Received on Thu Aug 30 2001 - 05:22:25 CEST