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@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 - 02:18:33 CDT