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: interesting query problem, how to resolve? Analytic functions?

Re: interesting query problem, how to resolve? Analytic functions?

From: Jusung Yang <JusungYang_at_yahoo.com>
Date: 29 May 2003 09:13:59 -0700
Message-ID: <130ba93a.0305290813.77229260@posting.google.com> 





depifster_at_yahoo.com (Jack Silvey) wrote in message news:<25c7944d.0305280759.6a8b017a_at_posting.google.com>...


> Anurag,

> 

> This database is 8.1.7.4.0.

> 

> You are right - my example negected the join between member and claim.




Not only that. The SQL could have been simplified with a 'NOT EXISTS'
between claims and drugs. It may be easier if you provide some real
data and indicate what kind of output you are looking for.





Received on Thu May 29 2003 - 11:13:59 CDT












Original text of this message













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