Join three table in mysql

See more:

C#

I have three table as follow

-------
table name Person
----------
PersonId
HomeId
FirstName
Email
Gender
Password

====================================
table name NoticeBoard
-------------------------
NoticeBoardId
NoticeTitle
Notice
CreationDate
PersonId

=====================================
table name Home
-------
HomeId
HomeNumber
HomeName


I want to make search sql query...
as like..
If I want to find person name, Person HomeNumber and NoticeTitle so how to find following query can not work..

ALTER PROCEDURE dbo.sp_Custom_Select_Complain
(
	@PersonId int = NULL,
	@FirstName varchar(50) = NULL,
	@Gender varchar(50) = NULL,

	@ComplainId int = NULL,
	@ComplainTitle varchar(100) = NULL,
	@ComplainInfo varchar(400) = NULL,
	
	@HomeId int = NULL,
	@HomeNumber int = Null,
	@HomeName varchar(50) = Null

)
AS
select 
	P.FirstName,
	P.Gender,

	C.ComplainTitle,
	C.ComplainInfo,

	H.HomeNumber,
	H.HomeName

From Person P 
	Inner Join Complain C On C.PostId = P.PostId
	Inner Join Home H On H.HomeId = P.HomeId

Where 
	(@PersonId Is Null Or P.PersonId = @PersonId)
AND	(@FirstName Is Null Or P.FirstName LIKE '%' + @FirstName + '%')
AND	(@Gender Is Null Or P.Gender = @Gender) 

AND	(@ComplainTitle Is Null Or C.ComplainTitle LIKE '%' + @ComplainTitle + '%') 
AND	(@ComplainInfo Is Null Or C.ComplainInfo LIKE '%' + @ComplainInfo + '%') 

	RETURN

----------------------------------------------
please help me...