One 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.
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.
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.
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.
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:
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.
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.
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.
The result will be: 3, 5
Clean up table
Remove duplicate recipients
Remove duplicate records
Filter through text file
Working with tables