[V4MD] findAllLinked from two subTables

[Ruslan Zasukhin]

On 9/20/05 11:34 PM, "info at vallemediatime.com" <info at vallemediatime.com>
wrote:

> Ho Ruslan
> I try to explain you (better I can) with a simple example:
> 
> T1
> ID  |  Person  |  Phone  |  Code
> ------------------------------
> 1      Brown      123        1
> 2      Smith        456        2
> 3      Parker      287        1
> ....
> 
> T2
> ID  |  Course  |  Level
> ------------------------
> 1      Science     1
> 2      Math         1
> 3      Math         2
> ...
> 
> I create a link between T1<>T2
> 
> When I search allLinked I need to get, not only linked from T1 to T2 like
> this:
> eg find allLinked to Math, show from T1
> 1      Brown      123        1
> 2      Smith        456        2
> 
> but also the Person with Code = 2
> 2      Smith        456        2

It is late here, and I read by one eye now :-)

Quick answer: it seems you need FULL OUTER JOIN of SQL

 
> in the same time (if possible) I wnat to get the Math Level 1 or 2 also
> 
> My idea is in this pseudo code;
> findAllLinked from T1 to T2
> show only T1 Person with Code = 1
> where T2 Linked Courses have Level = 2
> 
> I hope that you can understand me :-)

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