[V4MD] OR query results

[Ruslan Zasukhin]

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

> At 17:32 19.12.2003, you wrote:
>>> 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.
> 
> sorry, I thought I wrote that in the first mail. here's the structure:
> 
> table a: title, type_ptr (->table b->type_name)
> table b: type_name

Then above query should works, I think.

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