Hi
I have a database table with two columns, Nname,NParent. Data are like;
Nname ,NParent
n1 ,origin
n2 ,n1
n3 ,n2
n4 ,n2

So what I want is a SQL statement , given a particular Nname( say n2) you should return all Nnames which has n2 as the parent; i.e n2,n3,n4.
I think this is something to do with a co-related subquerry. Please give me this urgent help.

thanks