[V4MD] OR query results

[Martin Kloss]

At 17:26 19.12.2003, you wrote:
>Yes, OR not works if fields are from different tables.
>And there is no easy workaround.

hmm, does that mean that "AND" works? so the following should work:

SELECT title, type_name FROM a, b WHERE (type_name = 'red' AND type_name = 
'blue') AND (title LIKE '(?i)foo' OR title LIKE '(?i)bar') AND (title NOT 
LIKE  '(?i)test')

Correct?

Martin.