Binary links and SQL

[Bart Pietercil]

On 14-feb-07, at 20:29, Ruslan Zasukhin wrote:

> On 14/2/07 3:34 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:
>
> Hi Bart,
>
>> We defined a binary link 1:M between T1 and T2
>> So there are no Objectpointers or fk in T1 or T2
>
> ok
>
>> 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

TIA

Bart Pietercil