Binary links and SQL

[Ruslan Zasukhin]

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

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

See my and Ivan's emails in letter header.



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