query returning 0 records

[dogdays]

I have two queries, one returns 0 records, the second returns 1 record.
Both queries were generated using query design.
I am missing something and it is driving me nuts.
The WHERE clause does contain a valid tvoterID.
No error messages were generated.

' this query returns 0 records

SELECT tblVoters.tVoterId, 
       tblVoters.tVoterType, 
       tblVoters.tStatusCode, 
       tblVoters.tLastname, 
       tblVoters.tFirstName, 
       tblVoters.tMiddleName, 
       tblVoters.tPrefix, 
       tblVoters.tSuffix, 
       tblVoters.nStreetNumber, 
       tblVoters.tStreetname, 
       tblVoters.tStreetName2, 
       tblVoters.tZipcode, 
       tblVoters.tZip4code, 
       tblVoters.tCity, 
       tblVoters.tUnit, 
       tblVoters.tSuffixA, 
       tblVoters.tSuffixB, 
       tblVoters.tState, 
       tblVoters.tPartyCode, 
       tblVoters.tSex, 
       tblVoters.dtBirth, 
       tblVoters.tCongressionalDistrict, 
       tblVoters.tStateSenateDistrict, 
       tblVoters.tStateRepDistrict, 
       tblVoters.nAge, 
       tblVoters.nSupportCode, 
       tblVoters.nIssueCode, 
       tblComments.tHomePhone, 
       tblComments.tMobilePhone, 
       tblComments.tEmail, 
       tblComments.tComments
FROM (tblVoters INNER JOIN tblComments ON tblVoters.tVoterId = tblComments.tVoterID)
     INNER JOIN tblMailingAddress ON tblVoters.tVoterId = tblMailingAddress.tVoterID
WHERE tblVoters.tVoterID = '23000550548';


' this query returns 1 record

SELECT tblVoters.nHouseholdNumber
FROM tblVoters
WHERE tblVoters.tVoterID = '23000550548';

 

[Norie]

Does the tVoterID you are using in the criteria appear in all the tables in your join?

Are you sure you are using the right type of join perhaps you should be using LEFT JOIN?

 

[xenou]

Agreed - because of the inner join, you would get zero results if the particular VoterID did not exist in either of the tblComments or tblMailingAddress tables.

 

[dogdays]

Thank you Norie and Xenou, when I changed to LEFT JOIN all is well.