hello friends i am new to this post, i want to create a trigger which would read a row from 1st table match the related match from the 2nd table and on getting the appropriate match it would extract those rows from the table and keep them in new table so on doing this when i try to do this i won't get the redundant data the main problem is i am having tables having no common coloumns and no primary key i want to join these but i am unable to get the correct format so can anyone help me please..... i am stuck at this point please any help will be greatly appreciated. thanking you in advance please help me..