Hello, All,

I am trying to figure out how to join multiple tables, pulling all null and non-null values for certain criteria. I need to pull answers from a single question, whether the answers were left blank or not, as well as the respondent type (i.e. "Constituency"). I have tried a combination of INNER JOIN, RIGHT JOIN, and LEFT JOIN, and this works fine when I am pulling information for two tables only. However, the respondent type is in another table that is not directly linked to the other two tables, but it is indirectly linked via a fourth table, Respondents. Below is a diagram of the relationships between all four tables. I want a SQL statement that pulls the Anwers (from the tbl_Question_List_Answer) for question ID 875, for project 11, as well as the Constituency from the tbl_Constituency. I want all answers, even if left blank.

Suggestions? Thank you!


Relationships.JPG