Recursive Query
From: Ray <rfelipe_at_earthlink.net>
Date: 18 Mar 2003 12:16:27 -0800
Message-ID: <2ee70ad6.0303181216.3ad7573b_at_posting.google.com>
Hi,
Date: 18 Mar 2003 12:16:27 -0800
Message-ID: <2ee70ad6.0303181216.3ad7573b_at_posting.google.com>
Hi,
I have a table with an Id that references itself recursively and need
help building the query.
Here's the table structure:
The supervisor_id refers to the employee_id depending on who is the
employee
My resultset should look like:
employee_id PRIMARY_KEY
employee_name
supervisor_id
supervisor.
Thanks,
-Ray Received on Tue Mar 18 2003 - 21:16:27 CET