User-1129594362 posted
Here is My Table
R1 A1 B2 StatusId
1 100 100001 1
2 1122334455678 100001 1
1 100 100002 2
1 100 10045 1
2 1122334455678 1000046 2
My UserID is 10001
A1 is My FriendID A1 has requested the B2
Now I want to get My Request From the column B2 and Also Id who has accepted the request based on the status column
1 - pending
2 - accepted
I want O/P like as follows
R1 A1 B2
1 100,100002 100001