Re: Simple query/ table design question

try a subquery

kilidire wrote:

> 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- - 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
>
> 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 Mon Aug 27 2001 - 09:15:34 CEST