Because there are different numbers of fields in the two tables, none of the records will be exactly the same. If the 10 fields in Table A are also in Table B, then you can compare that part of the record.
Because you mention script, I'm guessing you want an SQL statement. It would go something like:
select * from TableA A, TableB B where A.f1 = B.f1 and A1.f2 = B.f2 and A.f3 = B.f3 ... and so on until you've got all of the fields you want to compare.
Note, unless you have an index on these ten fields on both tables, it will scan every record in the table and will be slower depending on the number of records.
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.