I've been battling lots with a complex query that is now turning out to be way too slow.
I've attached a stripped out database if someone is willing to put some fresh eyes on the problem.
1. The Slow Query is called "FPStatus-New"
2. I'm sure the problem lies with QA and QI getting their data from Query called: "QualiCompTypeFinal"
3. I created a table to test all results called "TestMe" - So the final query should deliver exactly the same data as contained in "TestMe"
Would really appreciate some help with this.
Thanks a lot