Show Null Values (1 Viewer)

[cybersardinha]

Hi,

I have made a query:

SELECT tblPerson.PersonName AS Name, Last(tblPersonCert.CertDate) AS Datum
FROM tblPerson INNER JOIN (tblCert INNER JOIN tblPersonCert ON tblCert.CertID = tblPersonCert.CertID) ON tblPerson.PersonID = tblPersonCert.PersonID
GROUP BY tblPerson.PersonName, tblCert.CertName, tblPerson.StartDate
HAVING (((tblCert.CertName)="Hygiene"))
ORDER BY tblPerson.PersonName;

I wanted this query to show all entries on tblPerson.PersonName, also when there isn't any Value on CertDate.

Is this possible?

Thanks

 

[CJ_London]

change INNER JOIN to LEFT JOIN

not sure why you have aliased here

tblPerson.PersonName AS Name

but Name is a reserved word and should not be used for field names

 

[cybersardinha]

Thanks, I've changed the field name.

I did that command with the query assistant.

When I change to LEFT JOIN i get an error that says something like JOIN-expression not used (I don't have access in English so I just translated)