I have two tables with 1 common field.I have to update the value of column1.1 in table1 by the values of column2.1 from table2.The prblem is table1 does not have a primery key it has a composite key(column1.1,column1.2).Please try to find out the solution.Thanks