rnivash

Try the following query,

update friends set msg = @msg ,friendID =members.id from (select @email as tmpEmail) as temptable

join members on temptable.tmpEmail = members.email where friends.uid = @uid

Do you really think this syntax is correct?