>Hi All,
>I have two tables that I need to compare. I was thinking of scaning through one, and comparing the data row-by-row to the other. Has anyone ever done this kind of theing before?
>TIA,
select * from FirstTable ;
union ;
select * from SecondTable ;
into cursor curFirstSec
This cursor will have all records from the first table + only records, which are different from the second table.
If it's not broken, fix it until it is.
My Blog