hi friends i am new to this forum and i want to create a trigger which would read one record from the 1st table match that appropriate digits from the 2nd table and on matching it would save those records in new table and these records will be deleted from second table so that when i search with the new record i won't get the redudant data but the problem i am facing is i am having the tables with no common coloumn in either of the tables and no primary key in any of the table so can any one help me please....