>Is there a way to compare 2 tables with the same structure and identify the differences?

select myTable1.* ;
union 
select myTable2.* into cursor curPossDiff

select ID, count(*) as Dups from curPossDiff group by ID having Dups > 1 ;
into cursor curChangedIDs

select * from curPossDiff cs LEFT JOIN myTable1 on cs.ID = myTable1.ID ;
where myTable1.ID IS NULL into cursor curAddedRecords

Easy to find deleted records too.

select myTable1.ID from myTable LEFT JOIN myTable2 on myTable1.ID = myTable2.ID ;
where myTable2.ID IS NULL into cursor curDeletedRecords