Hi Fabio,

>If you add this index ( ALSO TEMPORARY BEFORE EXECUTING THE SELECT ) to child table<

Thank you sir. You have saved me a lot of time in figuring all this out.

Mel Cummings