test/sql/Join/exp.test017.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 Statement Executed
   8 Statement Executed: Rows Affected = 1
   9 Statement Executed: Rows Affected = 1
  10 Statement Executed: Rows Affected = 1
  11 Statement Executed: Rows Affected = 1
  12 ---------------------------------------------------------
  13         emp.eno emp.ename       emp.dno
  14 ---------------------------------------------------------
  15         1       Nihar   10
  16         2       Papu    20
  17         3       Sima    30
  18         4       Nama    40
  19         5       Pinu    50
  20
  21 ---------------------------------------------------------
  22         dept.deptno     dept.dname      dept.lid
  23 ---------------------------------------------------------
  24         20      IT      101
  25         40      Sales   102
  26         60      Mkt     103
  27         30      Store   104
  28
  29 ---------------------------------------------------------
  30         emp.eno emp.ename       emp.dno dept.deptno     dept.dname      dept.lid
  31 ---------------------------------------------------------
  32         1       Nihar   10      20      IT      101
  33         1       Nihar   10      40      Sales   102
  34         1       Nihar   10      60      Mkt     103
  35         1       Nihar   10      30      Store   104
  36         2       Papu    20      20      IT      101
  37         2       Papu    20      40      Sales   102
  38         2       Papu    20      60      Mkt     103
  39         2       Papu    20      30      Store   104
  40         3       Sima    30      20      IT      101
  41         3       Sima    30      40      Sales   102
  42         3       Sima    30      60      Mkt     103
  43         3       Sima    30      30      Store   104
  44         4       Nama    40      20      IT      101
  45         4       Nama    40      40      Sales   102
  46         4       Nama    40      60      Mkt     103
  47         4       Nama    40      30      Store   104
  48         5       Pinu    50      20      IT      101
  49         5       Pinu    50      40      Sales   102
  50         5       Pinu    50      60      Mkt     103
  51         5       Pinu    50      30      Store   104
  52
  53 echo select * from emp where emp.deptno between 20 and 40;
  54 Statement prepare failed with error -19
  55 echo select * from emp,dept where emp.deptno between 20 and 40;
  56 Statement prepare failed with error -19
  57 echo drop table emp;
  58 Statement Executed
  59 echo drop table dept;
  60 Statement Executed