Re: Problem with LEF OUTER JOIN

[Sebastien Caisse]

You have to discard null values just the same in Access given a proper query.

Example:

SELECT * FROM table1 LEFT JOIN table2 ON (table1.id = table2.table1IdRef AND table2.itemType = "Deleted") WHERE table2.itemType IS NULL;

This would essentially select the rows from table1 (and table2...) which are NOT "Deleted".

This is actually a pretty bad example in design in most circumstances, but it's simple enough to show the use of doing such a thing.



Edited 1 time(s). Last edit at 03/23/2006 08:07AM by Sebastien Caisse.