> This is a case of bad table design. > > What if an employee has more than one manager?
Well, in this example, perhaps yes, but what about instances where this type of relationship is ensured? E.g. the typical threaded discussion where each message has 1 and only 1 parent message. I don't have a test environment where I could readily try this out (and I assume, Jon, that you'll know off the top of your head)...out of curiosity, is Torque capable of doing the same-table inner join, regardless of whether it's bad design or not? Thanks, Stephen -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
