test/sql/Join/exp.test130.ksh

   1 Statement Executed
   2 Statement Executed: Rows Affected = 1
   3 Statement Executed: Rows Affected = 1
   4 Statement Executed: Rows Affected = 1
   5 Statement Executed: Rows Affected = 1
   6 Statement Executed: Rows Affected = 1
   7 ---------------------------------------------------------
   8         emp10.eno       emp10.ename     emp10.job       emp10.mgrno
   9 ---------------------------------------------------------
  10         1       ALLEN   SALES   4
  11         2       PITTER  IT      3
  12         3       JACK    MKTING  1
  13         4       TOM     CLERK   1
  14         5       HARRY   MANAGER 5
  15
  16 echo SELECT emp.ename,mgr.ename FROM emp10 as emp,emp10 as mgr WHERE emp.mgrno=mgr.eno;
  17 ---------------------------------------------------------
  18         emp.ename       mgr.ename
  19 ---------------------------------------------------------
  20         ALLEN   TOM
  21         PITTER  JACK
  22         JACK    ALLEN
  23         TOM     ALLEN
  24         HARRY   HARRY
  25
  26 Statement Executed