Forum Discussion
Solved
Missing data when joining tables in a query?
I'm brand new to Access, so not sure if I'm even asking the right question. I have one Table, tblStudents, that has many rows of students with columns such as student ID, student name, student me...
First a bit of fiddly terminology accuracy.
"Cells" are in Excel and Word. In Access, you have "Fields" in tables, not cells.You have an INNER JOIN, which as you realize only returns records which match on MentorID.
If you want to return ALL records from one table, and only MATCHING records from the other table, you need to use an OUTER JOIN.
First a bit of fiddly terminology accuracy.
"Cells" are in Excel and Word. In Access, you have "Fields" in tables, not cells.
You have an INNER JOIN, which as you realize only returns records which match on MentorID.
If you want to return ALL records from one table, and only MATCHING records from the other table, you need to use an OUTER JOIN.
Thank you so much!