Compare tablesOne of the most advanced Database tools PostCast can offer. It will enable a simultaneous two table operation respectively, as well as their records' comparison. You can delete the records easily, or create a new table featuring results.
 Table Use this combo box to choose Table1 and Table2 names respectively, whose records you will then compare. Remember, you cannot compare the table with itself. If you wish to discard copies or employ other operations on a table, use other tools. Field Select a space for each table, according to which you would be comparing tables. For example, when you want to search all the e-mail addresses common to both tables, choose the column name wherein your e-mail addresses are kept. Remove results If you keep this option active, the program will erase all the table records that do not coincide with the selected criteria. For instance, if you keep it active for Table1, and deactivated for Table2, the program will erase the results from the first table. Table2 will remain untouched. Create backup copies of the tables before using this tool If this option is active, the program will create backup copies of the table using names that will be created from the table name + '_Backup', rather than perform any other operation. Create new table with the results You would enter the name of the new table and the program would create a new table wielding comparison results of the two different tables. Actions: Find only the values that exist in both tables Select this option if you want the program to search for data which can be found in both tables. For example, if you are comparing tables with records as follows: Table1Table2 11 23 45 66 The result will be: 1, 6 Find only the values that DON'T exist in both tables The program will be searching only for data which do not coincide with a single datum in the other table. Example: Table1Table2 11 23 45 66 The result will be: 2, 4, 3, 5 Find the values that exist only in 'Table1' and not in 'Table2' The program will search only for the data which form a part of Table1, and cannot be found in the other table. Example: Table1Table2 11 23 45 66 The result will be: 2, 4 Find the values that exist only in 'Table2' and not in 'Table1' The program will search only for the data which form a part of Table2, and not in the other one. Example: Table1Table2 11 23 45 66 The result will be: 3, 5 Clean up table Remove duplicate recipients Remove duplicate records Filter through text file Remove domains Repair database Compact database See Also: Working with tables Database Wizards E-mail merge | 
