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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only