siddharth_kcr
want to update [msg] and [friendid] field in friends table where friendid is in members table



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


I dont't find any meanig from the above operation becuase you mentioed,


siddharth_kcr
"@msg", "You have received a friend request from " + returnName(uid)


You have used "uid" as request sender but again updating the same user.. please check that too..

Regards,
Nivash Ramachandran.