Oracle Big Problem !

Hi,
I'm haveing some problem with Oracle Sql.

I'm in this situation :

---Table FATHERSON---

FATHER ---- SON

A           B
A           C
C           D
C           E
E           F
G           I
G           C

I need to return, for example, only the sons starting from C :

C           D
C           E
E           F

I use Oracle 9 and I know that there's the function CONNECT BY PRIOR but it doesn't work in my case because I undestood it needs a primary unique key and in my case it's impossible.

Can someone help me ?

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG