Re: SQL - filtering data based on AND condition

gospar wrote:

> Definitly no, because it returns all persons who speak english OR german.
> Instead, it should return all persons who speak English AND German.
>
> "JA" <ovan(makniovo_at_net.hr> wrote in message
> news:bbkuqn$kec$1_at_sunce.iskon.hr...
> > > SELECT p.PERSON_ID, p.NAME
> > > FROM LANGUAGE_SKILL l, PERSON p
> > > WHERE l.LANG_ID in (1,2);
> >
> > znaci ime osobe koja govori jezike 1 i 2
> >
> >

Simple problem or not this is a homework assignment from a class you are taking and no one here should do it for you.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)