[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