Need help syncrhonizing data between 2 tables automatically. Table A and B have the same data both have the same PK, I want to automatically do the following
1) If PK in A but not in B, automatically add record to B
2) If PK not in A but in B, set the status flag of record in B to inactive
3) If PK exists in both A and B, check a date modified field in A and B and update record in B if appropriate.
A and B hold employeeid, name, department and date fields.