Simple query/table design problem

From: kilidire <yc_at_hwcn.org>
Date: Thu, 30 Aug 2001 03:15:31 GMT
Message-ID: <3b8dad68.22010719@news>

Hi all,

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

eg
Table language :

ind - lan

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

C- - english
C- greek

C  - norwegain
D  -   french
D  -   chinese

D - english

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

select distinct ind from language where lan='english' and lan='french' ?
That doesn't work ...

Thanks all. Received on Wed Aug 29 2001 - 22:15:31 CDT