left outer join

[safra]

Hi,

I have 2 tables and want to find all entries that match on field "memberid" of table1 and check table2 if there is an entry that matches on field "uniqueid" which is a field in both tables:

select * from table1 LEFT OUTER JOIN table2 ON table1.uniqueid=table2.uniqueid where table1.memberid='102312'

This works fine. However, one of the search filters is search for all entries in table 1 with no record available in table2. I tried several things like:

select * from table1 LEFT OUTER JOIN table2 ON table1.uniqueid=table2.uniqueid where table1.memberid='102312' AND table2.uniqueid=null

No records returned while it should.

Anyone knows how to do this?

Thanks!

[Lars_Berg]

table2.uniqueid is null

[safra]

Thanks Lars, works well!