Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help writing SQL query

Re: Help writing SQL query

From: GQ <dbaguy_ott_at_yahoo.com>
Date: 7 Dec 2004 19:14:19 -0800
Message-ID: <1102475659.120709.47030@z14g2000cwz.googlegroups.com> 





I believe the following query will produce the result you want.
Select distinct TF1.fx1 AS familymember1
from (select familymember1 as fx1, familymember2 as fx2
from family


union


select familymember2 as fx1, familymember1 as fx2
from family) TF1


connect by nocycle prior TF1.fx1 in (TF1.fx1, TF1.fx2)
start with TF1.fx1='Brian';
Received on Tue Dec 07 2004 - 21:14:19 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US