stephen- Tuesday, May 25, 2010, 3:08:33 PM, you wrote:
> if you want to remove duplicate keys - put the imported data immediately > into an array. Duplicates are automatically eliminated. I was going to suggest something similar, but then thought this seems like a long way to go around for the desired result. Why not take the recordsets from the two database queries and use them on the fly to populate tables in a new database? Then you can run your sql matching statement on the new tables and delete the temporary database when you're done. -- -Mark Wieder mwie...@ahsoftware.net _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution