Binary links and SQL

[Ruslan Zasukhin]

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


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