Compare data between 2 array

Hi all, I would like to say good job to this newsgroup , they are the best. Ok. My dilemma is that i have to compare values between 2 table which are exactly the same structure and fields. Below is rough example . The table are tbl_chassis and tbl_chassis_temp. Below are the fields. id int(11) NOT NULL auto_increment, serial_no varchar(100) NOT NULL default '', host_name varchar(100) NOT NULL default '', chasis_model varchar(100) NOT NULL default '', chasis_flash_size varchar(100) NOT NULL default '', chasis_dram_size varchar(100) NOT NULL default '', chasis_sw_version varchar(100) NOT NULL default '', chasis_eos date NOT NULL default '0000-00-00', chasis_eol date NOT NULL default '0000-00-00', chasis_user_field_1 varchar(100) NOT NULL default '', chasis_user_field_2 varchar(100) NOT NULL default '', chasis_user_field_3 varchar(100) NOT NULL default '', status varchar(100) NOT NULL default '', What i need to figure out are when the records are deleted , updated and insert ,i need to update status in tbl_chassis table. What i am plan to do is to select query in the tbl_chassis_temp table and compare the value from each records to the records in the tbl_chassis table.Any others ways to do it? There are about 1000 records in each table. What is the better alternative to do this ? Thanks - weetat