Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL - filtering data based on AND condition

Re: SQL - filtering data based on AND condition

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Wed, 04 Jun 2003 09:19:14 -0700
Message-ID: <3EDE1C02.F5D4B2D8@exxesolutions.com>

gospar wrote:

> 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
> >
> >

Simple problem or not this is a homework assignment from a class you are taking and no one here should do it for you.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Wed Jun 04 2003 - 11:19:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US