Re: get rows not present using join _AND_ where clause

Okay, Now I understand what you want. (For people who try to unsub me from this list: Sorry I only try to help, if you are not intressted in it pleasee dont read) If you start using MySQL 4.1 (Only ALPHA) then you can use subqueries like this: select * from table1 where id not in ( select re

Re: get rows not present using join _AND_ where clause

If I'm right you want to do a left join. For example: Table1: Id value 1 100 2 200 3 300 Table2: Id RefId OtherValue 1 1 9000 2 1 1 3 2 8000 If you do this: select T