Hi Gail,

My query is below. I've commented the field that I had to add to get the query to work. I'm only a sql novice so the code is...

select'Thanks Gail' union all

select'Most appreciated' union all

------------------------------

select'Regards.....Jason'

Hi Eli,

The query includes a calculated field that contains a correlated subquery which itself has 3 WHERE conditions. I can only get the query to work if i include all...

That's great...I really appreciate your help. Works a treat.

I realised half of the problem was the non-normalized table structure, but that's our IT team's responsibility - I'm just one...

Sorry if I wasn't clear.

The Range and Yearofvalue fields should be self-explanatory.

The other fields present prices for January, March, August & September (baseprice1, baseprice3, baseprice8, baseprice9).

What I'm trying to find...

Oops...forgot to say, I'm using SQLServer 2000.

Thanks,

Jason

___

That's the one. And would you believe probably the only combination I didn't try before posting.

Thanks again,

Jay

For a good beginner's guide you can't do much better (IMHO) than:

"SQL Queries for Mere Mortal" by Viescas Hernandez,

Jason

___