 how to join two tables having no primary key and no common coloumns
hi friends i am new to sql server can anbody show me how to join two tables having no common coloumns and no primary key in them , i want to create a trigger which will read 1st table 1st row match the value from 2nd table and then keep the record it in new table and delete that row from the original table so that when the table is readed again it would not give me redundant data so can anybody help me please... | 
