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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Simple query/table design problem

Re: Simple query/table design problem

From: Christian Haberbosch <haberbosch_at_web.de>
Date: 30 Aug 2001 04:49:42 -0700
Message-ID: <c8953686.0108300349.7274dc32@posting.google.com> 





> How am i going to query this table to find out who speaks english and

> french  ?

> The answer should be A, B and D

> 

> select  distinct ind  from language where lan='english' and

> lan='french'  ?

> That doesn't work ...

> 




hi,


just make two queries (one for english speakers and one for french
speakers) and INTERSECT the results.



Bye,


Christian.
Received on Thu Aug 30 2001 - 06:49:42 CDT












Original text of this message













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