Re: Simple query/table design problem

Christian Haberbosch wrote:
>
> > 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 ...
> >
>
> hi,
> just make two queries (one for english speakers and one for french
> speakers) and INTERSECT the results.
>
> Bye,
> Christian.

This works.

But my guess (based on Christian's first attempt) is that it is not what his teacher is trying to demonstrate.

-- 
Phil Singer                |    psinger1_at_chartermi.net
Oracle DBA