Binary links and SQL

[Mathieu Langlois]

No Table M is a master table, and T1 and T2 are 2 sub tables.  For
example, M could be Employees.  T1 could be Projects assigned to each
employee.  And T2 could be Orders from employees.  So
Employees:Project is 1:M, and Employees:Orders is 1:M.

So the following query should give you all the information about a
particular employee:

Select * from Employees
join Projects on LNK_Employees_Projects
join Order on Lnk_Employees_Orders
where employees.name = 'someone'

I have an example project if you can tell me where to send it.

On 7/16/05, Ruslan Zasukhin <sunshine at public.kherson.ua> wrote:
> 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]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>