I have had to do similar stuff before I wrote an perl application to create the SQL from the database directly. Point it at a table (or two) and it creates the select then edit the select. This is probs better than cut/paste. -- Zigster