I have 2 tables which I am comparing. In some cases, table A may have more records than table B. What I want to do is select all the records in table A that are not in table B, so that I can give the user the option to copy these selected records over to table B.
Is there an easy way to do this using some sort of Select command? I can't see how to do it. (I have MapBasic). My alternative method is to create a copy of table A as table C, then loop through each record in table C & compare with each record in table B and compare. If I get a match I throw it out of table C. This will be a loop within a loop & looks like it will take a long time. I'm sure there is someone out there that is smarter than me & can think of a quicker way! :-) Dave --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10056
