Re: How to write the select query on self referencing table.
From: Ed prochak <ed.prochak_at_magicinterface.com>
Date: 9 Sep 2003 10:57:59 -0700
Message-ID: <4b5394b2.0309090957.54907aef_at_posting.google.com>
Date: 9 Sep 2003 10:57:59 -0700
Message-ID: <4b5394b2.0309090957.54907aef_at_posting.google.com>
sreevennreddy_at_yahoo.com (sreddy) wrote in message news:<f7d639cb.0309081103.63c61c39_at_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.
Received on Tue Sep 09 2003 - 19:57:59 CEST