Query missing results

[awayhere]

Hello,

My issue is that I have a query that should essentially return an entire table but it is missing some entries. The entries that are missing appear to be entries that do not have a value when I do a lookup.

SELECT Perm.PermSequence, Perm.SeqNo, (and more fields)
FROM tblType INNER JOIN (Status INNER JOIN (Description INNER JOIN Perm ON Description.[DESCN] = Perm.[DESCN]) ON Status.[Status No] = Perm.[StatusNo]) ON Type.[TYPEN] = Perm.[TYPEN];

I shortened the query to be more readable. Any time any entry is null for one of the three joins, it does not show the entry at all. How do I get it to still show the entry but with a blank?

Thank you,

[June7]

INNER join requires related records in all tables. Try using LEFT or RIGHT joins instead.

[awayhere]

You were absolutely right. I needed right joins. That allowed it to show all the data in the original table and the additional data only if the join applied. Perfect!