>why did you include the Status table in the first place ?
Because, this is a simplified version of the SQL. The original SQL is much bigger. But, I was able to simulate it in this small SQL. IAC, we have resolved the issue today by avoiding the use of the inner join.
>On the old "approaching 2 Gig" thread - any problem ?
We recommend to not cross post between threads. There is already some threads going on about this and posting the related topics in the related threads would help. As for me, I am not approaching it that much so far. At least, I am good for another two years I believe.