Agreed, I very often find myself having to write an advanced query just for these kind of cases. Alternatively allow NULL to be specified or implicitely test for it (so the second, non-joining condition can be added separately).