Can anyone please help in getting a solution... I have two table, 1 contains all details of a person with person id as primary key. the other table has person id and parent id both referring to person table person id. My query is i have to get all the parents of a given person name. Please help me in finding a query solution...
Table "person" Column | Type | Modifiers ------------+-----------------------+---------------------------------------------------- pid | bigint | not null default nextval('"person_pid_seq"'::text) first_name | character varying(50) | surname | character varying(50) | dob | date | Primary key: person_pkey
so if i give first_name of person = ????, then i have get all the parent ids. I tried nested query but tat resulted in 1 level parent alone. i want to get all parent id... please help me..!
Reagrds, Vignesh -- "A man who believes in himself and not circumstances is the real winner"
