Binary links and SQL

[Ruslan Zasukhin]

On 14/2/07 11:18 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

Hi Bart,

>>> How do we make it work in SQL what you would do in the API by doing
>>> FindLinked ?
>> 
>> E.g. Find records of T2 linked to some RECORD of T1?
>> 
>> SELECT T2.*
>> FROM T1 join T2 using link_name
>> WHERE T1.recID = xxx
>> 
> 
> Ok, but in the mean time I also looked at the -> operator
>   would it be possible to rephrase this as
> 
> Select T2.* From T2 WHERE m:1linknameToT1->recid = xxx ?
> 
> Just to sharpen my understanding

Yes this should work as I see.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]