Hi rajiv01
As per your table structure and table data your required output is totally wrong.
As per your question you need find the all friend request which is sent using sql.
So for that you need to match User_id column value from Tbl_register with req_to_id from tbl_friend_and_match_request table.
Also you need to apply inner join so all valid matching records will get display.
Refer the below sample test query as per your table structure and your table data.
SQL
DECLARE @tbl_register AS TABLE (UserID INT,f_name VARCHAR(20),Designationnm VARCHAR(20),Comapny_name VARCHAR(20))
INSERT INTO @tbl_register
SELECT 1,'aaa','CEO','Apple'
UNION ALL
SELECT 2,'Rajeev','General manager','Dell'
UNION ALL
SELECT 3,'upendra','Managing director','Dell'
UNION ALL
SELECT 4,'soumendr','Vice president','lenovo'
UNION ALL
SELECT 9,'Suneal','Managing director','Apple'
UNION ALL
SELECT 8,'asa','CEO','Apple'
DECLARE @tbl_friend_and_match_request AS TABLE (req_from_id INT,req_to_id INT,req_status INT)
INSERT INTO @tbl_friend_and_match_request
SELECT 2,9,0
UNION ALL
SELECT 3,9,0
UNION ALL
SELECT 4,9,0
UNION ALL
SELECT 2,8,0
UNION ALL
SELECT 2,1,0
SELECT tbl_Register.f_name
,tbl_Register.Designationnm
,tbl_Register.Comapny_name
,tbl_Register.UserID
,tbl_friend_and_match_request.req_from_id
,(SELECT f_name FROM @tbl_register T WHERE t.UserID = tbl_friend_and_match_request.req_from_id ) 'Request sent from'
FROM @tbl_register tbl_register INNER JOIN @tbl_friend_and_match_request tbl_friend_and_match_request
ON tbl_Register.UserID = tbl_friend_and_match_request.req_to_id
Output
f_name |
Designationnm |
Comapny_name |
UserID |
req_from_id |
Request sent from |
aaa |
CEO |
Apple |
1 |
2 |
Rajeev |
Suneal |
Managing director |
Apple |
9 |
2 |
Rajeev |
Suneal |
Managing director |
Apple |
9 |
3 |
upendra |
Suneal |
Managing director |
Apple |
9 |
4 |
soumendr |
asa |
CEO |
Apple |
8 |
2 |
Rajeev |