SQL Update query using Inner Join

update t1 set t1.sellingprice=t2.sp from Table_1 t1

inner join Table_2 t2 on t1.itemid=t2.itemid where t1.itemid=t2.itemid