Re: SQL - filtering data based on AND condition
From: gargantua <gargantua_hr_at_hotmail.com>
Date: Thu, 5 Jun 2003 09:18:33 +0200
Message-ID: <bbmqs0$ebh$1_at_garrison.globalnet.hr>
Date: Thu, 5 Jun 2003 09:18:33 +0200
Message-ID: <bbmqs0$ebh$1_at_garrison.globalnet.hr>
"gospar" <no.spam_at_my.place> wrote in message
news:bbku7s$juq$1_at_sunce.iskon.hr...
> Maybe you didn't understand the problem, but a simple query (if you tought
> so) won't solve it.
> The following IS NOT a solution for example 1 (Give me all persons who
speak
> English AND German):
>
> SELECT p.PERSON_ID, p.NAME
> FROM LANGUAGE_SKILL l, PERSON p
> WHERE p.PERSON_ID=l.PERSON_ID AND l.LANG_ID=1 AND l.LANG_ID=2;
A da dodas jos i jedan count(*) unutra koji mora biti jednak broju jezika koji govori?
p.s. Necu ti napisati SQL. Ipak moras nesto napraviti i sam.
Pozdrav, Marko Received on Thu Jun 05 2003 - 09:18:33 CEST