select *,bc.CONTRACT_AMOUNT_ contractAmount from biz_acceptance_settlement bas left join biz_project_management pm on bas.PROJECT_ID_ = pm.ID_ left join biz_contract bc on bc.ID_ = bas.CONTRACT_ID_