Access Database - Entities Not Linking

[jammy1812]

Hi guys,
I'm making a database to show a school and it's members, etc and I'm trying to run queries (and sub queries) to show how staff are allocated.

However, when I run the queries I've made, they don't seem to be returning the expected results.

For instance, I want a query to show:

faculty id, faculty name, person id, person firstname and surname, subject id and subject name.

I expect the format in the following:
1, Science, 1, Henri Blanc, 1, Biology
1, Science, 2, John Green, 2, Chemistry
1, Science, 3, John Black, 3, Physics
2 Arts/performing arts, 4, Joe Grey, 1, Biology
2 Arts/performing arts, 4, Kevin White, Chemistry

But when I run the queries, I get a list of all the members of the database and they're allocated to each faculty and subject...

Can anyone help me so that my database shows the proper allocations?