SQL Hierarchical SELECT
From: Rose Noel <rkamene_at_easynet.co.uk>
Date: Thu, 03 Jun 1999 00:38:56 +0100
Message-ID: <3755C090.3F87F640_at_easynet.co.uk>
Hello everybody,
I am trying to select some employee data from emp table without using the "CONNECT BY CLAUSE". Is it this possible using only SQL.
Date: Thu, 03 Jun 1999 00:38:56 +0100
Message-ID: <3755C090.3F87F640_at_easynet.co.uk>
Hello everybody,
I am trying to select some employee data from emp table without using the "CONNECT BY CLAUSE". Is it this possible using only SQL.
Empno Ename Mgr 7765 Scott 7788 7788 Jones 7839
This is the result of executing the query. I know Scott's EMPNO and I
want his details and that of his manager. How can this be done in sql
Cheers
RNK.
Received on Thu Jun 03 1999 - 01:38:56 CEST