Re: SQL - filtering data based on AND condition

From: gospar <no.spam_at_my.place>
Date: Wed, 4 Jun 2003 16:41:14 +0200
Message-ID: <bbl0bj$lip$1_at_sunce.iskon.hr>


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 - 16:41:14 CEST

Original text of this message