Returning results from non-existing entries

[lxh]

Hi there

This is my SQL select line

MySQL = "SELECT ProjectDetails.*, TeamMemberInformation.* " & _
    "FROM ProjectDetails INNER JOIN TeamMemberInformation ON " & _
    "ProjectDetails.ProjectDetailsID = TeamMemberInformation.ProjectDetailsID WHERE "

I am using it to perform a search on the project details and teammember information tables. My problem is that if there is no corresponding entry in the teammember table (for said project) then the search does not return the prpject details. Is there a way to return the project details even if there is no entry in the teammeberinformation table? - something like the Nz() function?

Thanks
Lex

 

[Kodo]

change INNER JOIN to LEFT JOIN.

 

[lxh]

Result!

change INNER JOIN to LEFT JOIN.

Does exactly what it should do
- but why?

Thanks
Lex

 

[Mile-O]

Does exactly what it should do
- but why?

INNER JOIN only selects records between tables where they both share a value

OUTER JOINS select all records from one table and only those records from the other table that match