query code check please

[Jen0dorf]

Hi



I have two tables

tblDeceased and tblMemorial

I want to list all the records in tblMemorials that are not in tblDeceased based on criteria

PlotNo, GraveNO and Mlink

ie if any record in tblMemorial does not match all three criterial it is listed as not being in tbl Deceased.

OK my code is here

[CODE
SELECT tblMemorial.Plot, tblMemorial.GraveNo, tblMemorial.Mlink
FROM tblMemorial LEFT JOIN tblDeceased ON tblMemorial.[Mlink] = tblDeceased.[Mlink]
WHERE (((tblDeceased.Mlink) Is Null)) AND (((tblDeceased.Plot) Is Null)) AND (((tblDeceased.GraveNo) Is Null));


][/CODE]

I think I've been looking at this for two long and hence I'm going a bit brain dead

Is my code good?

thanks

Ian

[ItsMe]

You will need some additional JOINS

Something like ...

SELECT tblDeceased.Plot, tblDeceased.GraveNo, tblDeceased.Mlink
FROM tblDeceased LEFT JOIN tblMemorial ON (tblDeceased.Mlink = tblMemorial.Mlink) AND
(tblDeceased.Plot = tblMemorial.Plot) AND
(tblDeceased.[GraveNo] = tblMemorial.[GraveNo])
WHERE (((tblMemorial.GraveNo) Is Null) AND ((tblMemorial.Plot) Is Null) AND ((tblMemorial.Mlink) Is Null))