Binary links and SQL

[Ruslan Zasukhin]

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

Hi Mathieu, 

> Can this be used to link several tables?

Yes should work.
 
> 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".

Please send database prototype to us. And add report into Mantis.

Before this try next:

SELECT * 
>From (M join T1 ON LNK_M_T1)
        join T2 ON 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]