Show when object field is null

[Accesfreak]

Hi all,



I have two tables. 'Table1' with names (and additional information) and 'table2' with images. I need a query that shows [table1].[name] where [table2].[picture] not excists. So far, I have:

SELECT [table1].[name] FROM [table2] LEFT OUTER JOIN [table1] ON [table2].[personID] = [table1].[personID] WHERE [table2].[picture] is null;

It does not work... Tried lots of things. Inner joins, where ... is ''.
Anybody a sugggestion?

[pbaldy]

I think you want RIGHT JOIN instead of LEFT OUTER JOIN, but I've never tried with a attachment field.

[Accesfreak]

I think you want RIGHT JOIN instead of LEFT OUTER JOIN, but I've never tried with a attachment field.

thx! works perfect.


(How could I close this topic or say it is solved??)

[pbaldy]

Happy to help. You can mark it solved in Thread Tools at the top of the thread.