[V4MD] OR query results

[Ruslan Zasukhin]

on 12/19/03 6:29 PM, Martin Kloss at martin.kloss at gmx.de wrote:

> 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:

AND works for JOINS, we use this each day.
OR query on fields from different tables is rare.


> 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, it is hard to answer, because I even do not see which fields to
which table belong.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------