select * from biz_preliminary_design bpd left join biz_project_management pm on bpd.PROJECT_ID_ = pm.ID_