Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
how can write mutual friends query
Gaurav Raj
Jul 13 2017 1:58 AM
196
Reply
CREATE TABLE [dbo].[Friends] (
[FriendshipId] INT IDENTITY (1, 1) NOT NULL,
[MyId] INT NULL,
[FriendId] INT NULL,
[Status] INT NULL,
[MeOnline] INT NULL,
[FriendOnline] INT NULL,
[PingStatus] INT NULL
);
--this view friends
CREATE VIEW [dbo].[frdsView]
AS
select MyId,Id,F_Name+' '+L_Name as Name,Pic,Counttry,case when Status=1 then'Friends' else 'Request send'end as friend from
RegisterTable full outer join FriendsTable on FriendId=Id
where MyId=MyId
--how can i find mutual friends
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
set character and numeric in grid cell
asp.net mvc how to do crud operations in mvc by using mysql