Left Join

[KoolKatelyn]

Hello,



I am having some difficulty executing a Query within Access 2013. I am trying to display information from 4 different linked tables. The problem is the last table in the Query is not displaying the data. I have drawn a relationship for the "ID number" which is the same in all 4 tables.

I went into SQL view, and changed the INNER JOIN'S to LEFT JOIN's. Is there another way to do this so that all my tables are displayed?

Any help or suggestions would be much appreciated.

Thank you so much!

[John_G]

If you are seeing all the rows in the query that you expect to see, but the data from that last table is blank, it suggests that the data in that last table is blank (i.e. the rows are there, but the field is blank). did you verify that you are displaying right table field?

Try including the "ID Number" from the last table as one of the query fields. If it shows correctly, then what I said above is probably the case.

[KoolKatelyn]

John - All of my tables have the same column, "ID Number", so that there is a common identifier between them. When I run my Query, the first three tables display all of the information that I want to see. However, the 4th table is not displaying my data. The Query will show the column headers of the 4th table, but it will not display the data that should is from that table. I viewed my Query as SQL view and updated all of the INNER JOINs to be LEFT JOINs thinking that that would resolve the issue, but it had no effect. I'm not sure what you are talking about above when you say "right table field". Can you please elaborate? Thank you

[orange]

Please copy and paste the SQL in a post.

Also, could you tell us a little more about these 4 linked tables?

Left join info

[John_G]

Sorry - by "right table field", I meant "the correct table field(s)".

Is the ID Number from that 4th table being displayed, or is that blank as well?