Jeff Amiel <becauseimjeff(at)yahoo(dot)com> writes:
>> At the moment I think the only way to work around this is
>> to denormalize
>> your schema a bit.
> And I feared as much.
> It's biting me in other areas as well...this unusual distribution of data...certain types of customers have completely different data patterns than others.
> Back to the drawing board...thanks!
I find your table structure anyway somewhat strange. For an ordinary
parent/child relationship a parent_id column in the customer table would
be enough. Do you really have an m:n relationship between parents and
children?