Re: SQL QUESTION (ADVANCED ??)

From: Jos Kerssens <jos_at_zeus.wnc.nedlloyd.nl>
Date: Wed, 7 Sep 1994 09:23:20 GMT
Message-ID: <1994Sep7.092320.27223_at_cti.wnc.nedlloyd.nl>

So far I got a number of answers to my question but, unfortunately, I still didn'y get the one I need.

Thanks a lot for the effort anyway.

Let me explain why the answers so far don't suffice.

Suppose I have a case like this:

   table A        table B       table C
   acol          acol ccol       ccol

    A1            A1 - C1         C1
    A2            A2 - C1         C2
    A3            A2 - C2         C3
    A4            A3 - C2         C4
    A5            A3 - C3         C5
                  A4 - C3
                  A4 - C4
                  A5 - C4
                  A5 - C5

My entry value is A1.

L. Scott Johnson's select statement would only give me:

A1
A2

Hank Robinson's first statement would give:

A1
A2

His second statement would give:

A1
A2

The statement of Larry Kramer would give:

A1
A2

And I really need:

A1
A2
A3
A4
A5

since they're all connected through the values of ccol. The table has (apart from the values above) also values that are not connected at all to A1 (f.i. A99 - C99 without any other record having A99 or C99). That's why I call A1 to A5 a 'group'.