from
 InvestmentScheduleD isd 
inner join
 investmentScheduleH ish 
on
 isd.PlanStepID = ish.PlanStepID 
inner join
 investmentPlanH iph 
on
 isd.PlanStepID = iph.PlanStepID
inner join
 investmentPlanD ipd 
on
 isd.PlanStepID = ipd.PlanStepID
where
 iph.InvestmentPlanStatus =1 and ish.InvestmentScheduleHStatus=1

------解决方案--------------------

select * 
from InvestmentScheduleD ,investmentScheduleH ,investmentPlanH ,investmentPlanD
where ...--这里把关系加上即可.