Anyone knows how to retrive difference information( changed rows , deleted rows , modified rows ) from 2 different tables with the same table strcuture ( same rows and same primary key ). Basically a similar kind of information generated at 2 differnt time interval and stored in 2 different table. I want to make a comparision what are the rows deleted , added and modified in those two tables.help me in this...

Thanks,