Binary links and SQL

[Mathieu Langlois]

Can this be used to link several tables?

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

This will give:
21:36:45: Error: Kernel error: 529669
21:36:45: Error: The table "T1" is not used in link "LNK_M_T2".

Normally this should return all fields from M + all linked fields from
T1 and T2.

Math

On 6/20/05, Ruslan Zasukhin <sunshine at public.kherson.ua> wrote:
> On 6/20/05 4:54 PM, "Mathieu Langlois" <realsoftlists at gmail.com> wrote:
> 
> Hi Mathieu,
> 
> > Hello, I have been evaluating the demo of valentina for Realbasic, and
> > I have one question.  Is there a way to use binary links on a SQL
> > Join?
> 
> Yes of course!
> 
> > With foreign keys, you have something like JOIN Table ON key =
> > ptr, but what syntax (if any) can be used for binary links?
> 
> SELECT
> FROM T1 join T2 on link_name
> 
> 
> 
> --
> 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]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>