Mark,

> Any ideas about getting the speed back? I don't see a
> fundamental reason for it
> to take so long. It must be doing things in the wrong order.

Well to start with your statement is potentially ambiguous, please try
full column references.

Next, why did you choose to use a FULL join? Wouldn't a LEFT JOIN been
more appropriate?

Finally, unless you have an index on Status, the system will be
performing joins for all 400,000 sawmember rows.


Sean