From: ed.prochak@magicinterface.com (Ed prochak)
Newsgroups: comp.databases.oracle
Subject: Re: How to write the select query on self referencing table.
Date: 9 Sep 2003 10:57:59 -0700
Organization: http://groups.google.com/
Lines: 10
Message-ID: <4b5394b2.0309090957.54907aef@posting.google.com>
References: <f7d639cb.0309081103.63c61c39@posting.google.com>
NNTP-Posting-Host: 64.215.235.66
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1063130281 31301 127.0.0.1 (9 Sep 2003 17:58:01 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 9 Sep 2003 17:58:01 GMT


sreevennreddy@yahoo.com (sreddy) wrote in message news:<f7d639cb.0309081103.63c61c39@posting.google.com>...
> I am trying to write a sql query on self referencing table.
> Just to brief ..Database is related to a  Hiring department of the
> Qwest company.
> 
Brief hint: consider the referal_nodes table to be two tables, one for
the employee, one for the referred by employee.

Ed Prochak
Magic Interface, Ltd.