sir, i want the result of 2nd( spGetWhoIsFrnd ) proc must not be in the 1st( spGetOtherUserInfo ) one.
ALTER proc spGetOtherUserInfo
@email nvarchar(50)
as
begin
select distinct FirstName,LastName,City,Photos,Cover,EmailID,
tbUserRgistrsn.UserName from tbUserRgistrsn
join tbProfileCoverPic
on tbUserRgistrsn.EmailID=tbProfileCoverPic.Email
where tbUserRgistrsn.EmailID <> @email
end
......................
alter proc spGetWhoIsFrnd
@email nvarchar(50)
as
begin
(select MyMail from tbMyFriends where FriendMail =@email and FriendStatus=3)
(select FriendMail from tbMyFriends where MyMail=@email and FriendStatus=3)
end