Re: SQL QUESTION (ADVANCED ??)
From: Jos Kerssens <jos_at_zeus.wnc.nedlloyd.nl>
Date: Fri, 2 Sep 1994 14:28:37 GMT
Message-ID: <1994Sep2.142837.13966_at_cti.wnc.nedlloyd.nl>
Date: Fri, 2 Sep 1994 14:28:37 GMT
Message-ID: <1994Sep2.142837.13966_at_cti.wnc.nedlloyd.nl>
Sorry...
I guess I didn't state my problem clear enough...
In the example I gave, Scott's solution will indeed work, but if I have a case like:
table B
acol ccol
A1 - C1
A2 - C1
A2 - C2
A3 - C2
A3 - C3
A4 - C3
.. etcetera
his statement will only give A1 and A2, but I need A3 and A4 as well since they are in my situation connected to A1 as well (they're all in 1 'group').
I hope this clarifies the problem.
--
Nedlloyd Computer Services _/ _/ _/_/_/_/ _/_/_/_/ P.O. Box 2454 _/_/ _/ _/ _/ 3000 CL Rotterdam (The Netherlands) _/ _/ _/ _/ _/_/_/_/ J. Kerssens _/ _/_/ _/ _/ _/ _/ _/_/_/_/ _/_/_/_/Received on Fri Sep 02 1994 - 16:28:37 CEST
-----------------------------------------------------------------------