Binary links and SQL

[Ruslan Zasukhin]

On 7/16/05 10:01 AM, "Mathieu Langlois" <realsoftlists at gmail.com> wrote:

>>> For example, I have table M, which is linked to T1 and T2 (but T1 and
>>> T2 are not linked together).
>>> 
>>> SELECT * From M
>>> join T1 ON LNK_M_T1
>>> join T2 ON LNK_M_T2

By the way.

Don't you use table M to get M : M link between T1 and T2 ?

If yes, then you should not that binary link self can do M : M

    T1 - link_T1_T2 - T2
        M           M




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