SQL query with NULL Value Comparison in MS Access

[mkc80]

I am trying to compare two tables and output results where a column in table1 and the same column in table2 are not equal.

The query looks like this:

Select Table1.Column1, Table1.Column2, Table1.Column3, Table1.Column4 from Table1 INNER JOIN Table2 ON
Table1.Column1 = Table2.Column1 AND Table1.Column2 = Table2.Column2 AND Table1.Column3 = Table2.Column3 WHERE
Table1.Column4 <> Table2.Column4;

Column1, Column2, Column3 together form the primary key for the two tables.

When Column4 has missing values (null), the corresponding record is not showing up as a mismatch in the resulting output.

(This is happening with other columns as well, be it Text or Number or Date/Time data type)



Any Comments?

[June7]

Try handling the nulls with Nz function:
WHERE Nz(Table1.Column4) <> Nz(Table2.Column4);