on 5/29/02 4:59 PM, "Chris McCann" <[EMAIL PROTECTED]> wrote:
> Greetings, > > Has anyone successfully used Criteria/Criterion to do an inner join on the > same table? Here's a sample table: > > create table employees ( > employee_id int, > employee_name varchar(50), > manager_id int > ); > > Note: the manager_id field is an employee_id, aka the self-reference. > > Any tips/pointers would be most appreciated. Thanks in advance. > > -chris This is a case of bad table design. What if an employee has more than one manager? -jon -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
