Viewing 3 posts - 1 through 3 (of 3 total)
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...
December 22, 2009 at 9:18 am
#1095456
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...
December 21, 2009 at 4:25 am
#1094669
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...
December 18, 2009 at 3:16 am
#1093935