Raul

>Hopefully you get your solution working (bug and all) but question : is this a one time operation or do you need to do this regularly.

Not yet and probably.

>If one time then creating a temp intermediary tables (do all joins so you're down to single table and then eliminate non-duplicates using your group by logic) might be faster as you'd have all the relevant IDs at the end that just need to be merged.

No matter what I do people will add duplicates and I can't just block them because there may be several (eg) Tim Youngs working for a company.

Roy Lambert

Tim

><< just to try and Forever = 1274.887 secs >>
>
>http://www.elevatesoft.com/supportfaq?action=view&category=edb&question=joins_where_clause

I know that but I thought I'd just see how long forever was

Roy Lambert