Newbie Question : Related tables and OR condition

[Ruslan Zasukhin]

on 9/19/03 5:22 AM, Greg DeVore at gdevore at mac.com wrote:

> 
> 
> I am having trouble with OR statements between two related tables.
> My SQL is this:
> 
> SELECT Title, Genre, Mood, Tempo, Comments, Composer, Collection, DVD,
> Publisher FROM Music_Library, Genre, Mood, Tempo, Composer, Collection,
> DVD, Publisher WHERE Title LIKE 'the' no_case OR MOOD LIKE 'tive'
> 
> The problem is that Valentina is treating this as if I had put
> "WHERE Title LIKE 'the' no_case AND MOOD LIKE 'tive'"

Hi Greg,

OR between fields from different table is not implemented in 1.x

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