Hi Experts,
I have need of a sql query to pull some data from the table below.
Premise:
Every project is assigned a project team. Every project have multiple phases. Each phase is assigned to a few employees. Each employee is assigned a role. I need a query that retrieves records for each project- phase that does not have an employee for the Back-up role. the query would produce the results highlighted below. Again the results should display records for project-phase where no back-up has been assigned. Thank you so much for your help.
Project 1001 Phase 3
Project 1002 Phase 2
Project 1005 Phase 2
I have need of a sql query to pull some data from the table below.
Premise:
Every project is assigned a project team. Every project have multiple phases. Each phase is assigned to a few employees. Each employee is assigned a role. I need a query that retrieves records for each project- phase that does not have an employee for the Back-up role. the query would produce the results highlighted below. Again the results should display records for project-phase where no back-up has been assigned. Thank you so much for your help.
Project 1001 Phase 3
Project 1002 Phase 2
Project 1005 Phase 2