>I have two tables namely 1. "studenta.dbf" with fields 1. id 2. name 3. dob 4. community 4. nationality 5. phy 6.maths 7. chemistry 8.total and another table namely 2."studentb.dbf" this table having same "studenta" table fields so both the tables having same fields and records. I want compare the two tables and extract the unmatched records and these records will sent report designer which I have already created.
>
> How to write code?

How deep should your match go? Whole record or only name? Unmatched records from both tables?

Anyway result should be no record since you state that fields and records are equal