Query handeling empty FK keys

[warlock916]

Hello everybody,

I have TblAnomalie that's my main table and has many FK. Everything worked fine untill I had to add row that don't have a value for some FK as in figure.

So when I run my query:



SELECT TblAnomalie.IDAnomalie, TblInfoAnomalie.IDFAnomalia, TblInfoAnomalie.ExId, TblInfoAnomalie.RifProtocolloNumVerifica, TblCause.NomeAnalisiCause
FROM TblSiti INNER JOIN (TblInfoAnomalie INNER JOIN (TblCause INNER JOIN TblAnomalie ON TblCause.IDCause = TblAnomalie.Cause_FK) ON TblInfoAnomalie.IDAnomalie = TblAnomalie.Info_FK) ON TblSiti.IDSiti = TblAnomalie.Sito_FK;

I don't get the rows with no value, even if I use "IS Null".

Can someone help me?

Thanks

[JoeM]

In order to return records where there is no match, you have to use LEFT JOINs instead of INNER JOINs.
See: http://www.techonthenet.com/access/queries/joins2.php