Hi,
I have 3 tables. People, Projects and Metrics. Table metrics holds IDs from People and Projects.
I'm trying to make a query. In this query I would like to see all of the people who are not assigned to the particular project. For example, I have a project with ID number 3. I also have 4 people in database. Person with ID number 1 and number 4 is assigned to project with ID 3. Now I want my query to show all of the people who are not assigned to the project number 3. So it should show two people with ID 2 and 3, and for those records IDmetrics does not exist. I've attached a sample of this database.
Thanks for your time.