Frank wrote:
>>Possible yes. Sensible no. This is just a bad denormalized design that
>>makes no sense. Fix the design and the problem goes away.
>>--
>
>
> Why bad design? It seems that it is a normal way of representing hierchical
> information in tables. Just like EMPLOYEES table has a MANAGER_ID column
> referencing another rows in the EMPLOYEES table. And, isnt it normal for
> one to select all the line managers of a given employee.
If that is what it is yes. But it was not apparent to me that that was
what it was.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sat Jun 25 2005 - 00:20:40 CDT
