select * from BIZ_CONSTRUCTION_DRAWING bcdd left join biz_project_management pm on bcdd.PROJECT_ID_ = pm.ID_