update table using select query

Hi,
I want to update a colmn in table1 using a column i table 2. query will be like update table1 set column1 = (selet column2 from table2 where column1=column2). Problem is table 2 can contain multiple rows with same column value and i need to update only one row in table1. It returns error multiple result set. Please advise with the correct query.Start Free Trial