showing Null rows in Count

[Judy]

okay I have a query that works fine, except I need to also
show the rows of Ethnic ID's with a count of zero or null.

How do I add that?

Here's the query:

SELECT tblClientInfo.ysnHispanic,
tclClientInfo.strEthnicID, Count
(tblClientInfo.strEthnicID) AS CountOfstrEthnicID
FROM tblEthnicity INNER JOIN tblClientInfo ON
tblEthnicity.EthnicID - tblClientInfo.strEthnicID
GROUP BY tblClientInfo.ysnHispanic,
tblClientInfo.strEthnicID;

thanks,

Judy

 

[John Vinson]

okay I have a query that works fine, except I need to also
show the rows of Ethnic ID's with a count of zero or null.

How do I add that?

Here's the query:

SELECT tblClientInfo.ysnHispanic,
tclClientInfo.strEthnicID, Count
(tblClientInfo.strEthnicID) AS CountOfstrEthnicID
FROM tblEthnicity INNER JOIN tblClientInfo ON
tblEthnicity.EthnicID - tblClientInfo.strEthnicID
GROUP BY tblClientInfo.ysnHispanic,
tblClientInfo.strEthnicID;

Change the INNER JOIN to a LEFT JOIN.

 

[John Spencer (MVP)]

Then you need to change the INNER JOIN to a LEFT JOIN.