I have 3 tables in my Database
tblUserInfo, tblVisitor and third one
tblInterest
table
tblUserInfo Contains User Information along with primary key UserID.
table
tblVisitor contains
VisitorId and
VistedProfileId
VisitorId and VisitedProfileId nothing but UserID in tblUserInfo
Table
tblInterest Contain
InterestFrom_UserID and
InterestIn_UserID and
InterestStatus
I want to get Details of user from t
blUserInfo,
But those user are in
tblVisitor
And get
InterestStatus from
tblInterest
the table
tblInterest may or may not contain record matches to
VisitorID
I want
if table
tblInteres not contain record matches to
visitorID then I want null value in
InterestStatus Field.
What I have tried:
My query as follow
SELECT tblUserInfo.UserAutoID, tblVisitor.VisitedProfileUserAutoId, tblUserInfo.UserFirstName, tblUserInfo.ProfileID,
YEAR(GETDATE())-YEAR(UserDOB) AS UserDOB,tblUserInfo.Height,tblUserInfo.Religion, tblUserInfo.Education,
tblUserInfo.Occupation, tblUserInfo.ProfilePicPath, tblInterest.InterestStatus
FROM
tblVisitor INNER JOIN tblUserInfo
ON
tblVisitor.VisitorAutoID=tblUserInfo.UserAutoID
JOIN tblInterest
ON
tblVisitor.VisitorAutoID=tblInterest.InterestIn
WHERE
tblVisitor.VisitedProfileUserAutoId=@VisitedProfileUserAutoId
AND
tblVisitor.VisitorAutoID=tblInterest.InterestIn
AND
tblVisitor.IsDeleted=0
When I fire above query I get only those recored that are in tblInteres