Sql string to show unmatched OR equal to string - posible?

[Sean Mc]

I have two tables - one has records called [tblFilTypes].[FilTypeList] the
other table has records called [tblPrts].[FilTypes], which is made up of a
subset of [tblFilTypes].[FilTypeList].

Relation:
[tblFilTypes].[FilTypeList] ~1:M ~[tblPrts].[FilTypes]

In [tblFilTypes].[FilTypeList] there is also one aditional record "ALL
FILE TYPES" which will never appear in [tblPrts].[FilTypes] .

What I am hoping to do is display all records from
[tblFilTypes].[FilTypeList] that have a match in [tblPrts].[FilTypes], the
related fields from [tblFilTypes].[HitCount], plus the aditional record from
[tblFilTypes].[FilTypeList] that = "ALL FILE TYPES" with its related
HitCount.

With the query wizard, it is easy enough to generate my sequel string that
will show only Matched records from [tblFilTypes].[FilTypeList]. :

SELECT tblFilTypes.FilTypeList, tblFilTypes.HitCount
FROM tblPrts INNER JOIN tblFilTypes ON tblPrts.FilType =
tblFilTypes.FilTypeList
GROUP BY tblFilTypes.FilTypeList, tblFilTypes.HitCount
HAVING ((Not (tblFilTypes.FilTypeList) Is Null))
ORDER BY tblFilTypes.HitCount DESC;

What I can't figure out how to add in is my record "ALL FILE TYPES".

IS this possible?

Thanks in advance for any help.
Sean Mc

 

[Jerry Whittle]

Try changing INNER JOIN to LEFT JOIN or RIGHT JOIN.