Re: SQL - filtering data based on AND condition

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Wed, 04 Jun 2003 19:02:40 +0200
Message-ID: <3EDE2630.1040603@science-computing.de>

gospar wrote:
> Hi Holger,
>
> "Holger Baer" <holger.baer_at_science-computing.de> wrote in message
> news:3EDE0148.7080401_at_science-computing.de...
>

>>Just think about what you're asking the database for:
>>
>>How in the world would it be possible for a given language_skill entry
>>to have at the very same time two (or more) different values?

>
>
> Two entries are required to describe that a person KNOWS two languages, and
> that is what I wrote in my examples.
>
>

>>I think Jimmy understood your problem perfectly well (as I do). He just
>>wanted to encourage you to first lookup easy syntax problems in any
>>SQL Book of your choice (the Oracle SQL Reference springs to mind) rather
>>than post to this NG.

>
>
> I still think you didn't understand it quite well. Try to write your
> solution.

I did, took me about 5 minutes time. Now do your homework.

Holger

PS: I'll get accused of helpfulness, but to get this thread stopped: what you need is

        a selfjoin on language_skill. Received on Wed Jun 04 2003 - 12:02:40 CDT