Re: Help writing SQL query

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)