Simple Querys with more then one left/right condition

By Luis Paulo Soares on 25 Sep 2012
On Simple Querys it should possible to have more then one left condition.

Implement something like:
Left table t2 on (t1.field = t2.field and/or condition2)

Kilian Hekhuis8 Oct 2012

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).