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: Help writing SQL query

Re: Help writing SQL query

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 06 Dec 2004 18:51:37 -0800
Message-ID: <1102387793.829553@yasure>


Barry Bulsara wrote:

>>"DA Morgan" <damorgan_at_x.washington.edu> wrote in message
>>news:1102349402.953970_at_yasure...
>>Daniel A. Morgan
>>University of Washington
>>damorgan_at_x.washington.edu
>>
>>barry wrote:
>>
>>As this seems to be school work my recommendation is
>>that you start off by reviewing the rules of normalization.
>>If the structure is corrected the solution becomes trivial.

> 
> 
> Thank you for your reply Daniel but it does not help me. Further I am 
> neither a school child nor need to understand anything about normalisation. 
> This is the structure of the information I have and I need some help writing 
> the SQL query to give me the required resultset. I do not believe this is as 
> you put it trivial. Repost below.

If the data was normalized the query would be trivial. As you seem to prefer to not fix the underlying problem you have a much more difficult problem. Perhaps someone else will help you swim upstream.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Dec 06 2004 - 20:51:37 CST

Original text of this message

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