How to get data from 3 different data tables?

See more:

SQL

MySQL

database

, +

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 tblUserInfo,
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