I guess you could call it a "Parent Key"... Either way, my question still stands...
-----Original Message----- From: Dave Newton [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 2:07 PM To: Apache Torque Users List Subject: RE: Tables with foreign keys to themselves don't maintain Listsofrelated rows. On Tue, 2003-09-23 at 17:01, Gary Baker wrote: > No, that's not true, the semantics may seem confusing, but it is > perfectly legal to have a self-referential foreign key (at least in > the databases with which I'm familiar DB2, SQLServer, Oracle). This > is really the only way to build a proper tree structure out of your > data. Oh. I guess it's just a matter of semantics then. I haven't done any trees using Torque, although I've done them "by hand" with MySQL, with index references to the same table. Thanks for the clarification :) Dave --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
