[SQL] Related table question

[Ruslan Zasukhin]

on 1/17/04 11:22 AM, Ruslan Zasukhin at sunshine at public.kherson.ua wrote:

> on 1/16/04 10:35 AM, Eric Forget at forgete at cafederic.com wrote:

>> 2. (A.Name LIKE "\AH") OR (Keyword.Name = "Me")
>> 
>>   Result:     CalcID      Label
>>               1           2
>>               2           3
> 
> This not works in 1.x
> OR on fields from different tables

Hi Eric, 

I was little wrong!

You can get such result in Valentina 1.x.

This is a query:

select A.calcId, A.label
from a
where   (a.Name LIKE '\AH' )
      or 
        a.RecID in (select ptr from keyword where name = 'Me' )


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