select * from biz_environmental_assessment bea left join biz_project_management pm on bea.PROJECT_ID_ = pm.ID_