Thanks. I tried this, but there appears to be some syntax error with it. Have never seen this kind of statement before so couldnt fix it somehow.

any more suggestions?

The NOT EXISTS doesn't help much. It mnages to reduce the reads but only by a very very tiny number. Any other suggestions? Appreciate the help.

Thanks, I'm not at work now. I'll try that first thing I'm in and will post the results.