Joins on same table?

[Chris McCann]

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

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>