Re: SQL - filtering data based on AND condition

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
>
>
Received on Wed Jun 04 2003 - 09:41:14 CDT