Hi Jill.

>It seems that a number of tables that I wouldn't THINK would appear in this query are there...other tables related to Defendants.

This can happen when you have circular relations ie. A -> B -> C -> A or A -> B -> C and A -> C, which appears to be the case here. As a result, SFQuery finds several ways to get from A to C and may not choose what you and I would see as the best path. Fortunately, I've rewritten the join engine to handle cases like this better, and once I've tested it more thoroughly, it'll be available in an update.

Doug