To alter your procedure use
Alter
keyword and how do we know your table structure and relation??
Alter PROCEDURE [dbo].[usp_GetCategoryByID1]
@ID int
AS BEGIN
select tblCategory.*,tblContractType.*,tblCategorySub.*
From tblCategory left outer join tblContractType on tblCategory.catContractTypeID=tblContractType.cttContractTypeID
inner join tblCategorySub on tblCategory.subcID= tblCategorySub.subcID
and tblContractType.cttisDelStatus='0'
where catID=@ID and tblCategory.catisDelStatus='0'
END