[V4MD] OR query results

[Martin Kloss]

At 16:24 20.12.2003, you wrote:
> > So I think comparing fields in different tables in a condition when you're
> > doing a join does not work in any case (AND / OR). Is that a limitation 
> that
> > will also be in 2.0?
>
>AND works 100%
>
>     WHERE a.id = b.ptr
>         AND a.f1 = 5
>         AND a.f5 > 8

Sorry, my fault. I meant the combination of alternating AND / OR
conditions over different fields does not work:

WHERE (a.f1 = 5 OR a.f2 = 2) AND (b.f1 = 3 OR b.f2 = 7)

Martin.