>Hi All,
> I have two tables that are supposed to be identical. One is at the home office and the other at a remote location. I was thinking of comparing each record one by one, but I was hoping there was an easier way. Has anyone had to compare two tables before and update the one that is outdated?
>Thanks,
select *, "TableA" as TableID from tableA ;
union ;
select *,"TableB" as TableID from TableB ;
into cursor FindDiff
select * FindDiff where FindDiff.Pk not in (select PK from TableA) && will give you records, which are different
If it's not broken, fix it until it is.
My Blog