SQL Join Query.
I am trying to query 3 tables in a database and I am not getting the results back that I am expecting.
Here is the query:
SELECT DISTINCT m.ADName, i.FirstName, i.LastName, r.Description
FROM Membership AS m INNER JOIN
user_information AS i ON m.ADName = i.NT_Username INNER JOIN
RolesDescription AS r ON m.RoleID = r.RoleID
WHERE (m.ApplicationID = 6)
I think its because a record does not exist in the "User_Information" (I would like the result to show a blank field if this is the case)
I am expecting 120 records but I am getting only 106.