Recursive Query
let i have 2 tables, table 1 say x1 has follwoing fields, id, name. The second table has follwoing fields, id, parent id. The id and parent_id are foreign key from table 1, and in table 2 they have inner join(like empno, mgr in emp table). Now i know that i can get recursive data by using connect by query, but what additional i need if i need the name field w.r.t id field of first table as resursive querry does not work for two tables.