Hi,
I have two tables A and B which are joined by the EmployeeBadgeID. I have to capture all the records that have changed in both the tables for a specifed from and to date. If the EndDate is not null in both the tables indicate that a record changed. How do I select only the records which have changed in both the tables for the specified from and to dates from the full outer joined table?