OK, so I updated the statistics for Prices and Products and the query now worked. Thanks a lot.

I haven't understood why updating the statistics changed everything though.

I'll give some information...

Hi

Thanks for your replies. I'm sorry I could not try out your suggestions and reply last week as I was very busy.

Wandrag, I updated the statistics for the temp...

Hi Wandrag,

Thanks for your query. However, it returns different results.

I'm copying my query again - I actually have a condition on the innermost select and I've renamed all code columns...