[V4MD] findAllLinked from two subTables

[info at vallemediatime.com]

Hi Ruslan,

----- Original Message -----
From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
To: <valentina-beta at lists.macserve.net>
Sent: Tuesday, September 20, 2005 11:08 PM
Subject: Re: [V4MD] findAllLinked from two subTables


> 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
Ok, I look for this in SQL reference; but before I must add binary link by
API and after do the SQL query... or before I must add link in SQL way?

>
> > 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]
>
>
> _______________________________________________
> Valentina-beta mailing list
> Valentina-beta at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-beta
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.344 / Virus Database: 267.11.0/103 - Release Date: 15/09/2005
>
>