[V4MD] OR query results
Martin Kloss
martin.kloss at gmx.de
Fri Dec 19 17:36:32 CST 2003
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
Martin.
More information about the Valentina
mailing list