test/sql/Join/exp.test014.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
   6 Statement Executed: Rows Affected = 1
   7 Statement Executed: Rows Affected = 1
   8 Statement Executed: Rows Affected = 1
   9 Statement Executed: Rows Affected = 1
  10 echo select * from emp;
  11 ---------------------------------------------------------
  12         emp.eno emp.dno
  13 ---------------------------------------------------------
  14         1       10
  15         2       20
  16         4       40
  17
  18 echo select * from dept;
  19 ---------------------------------------------------------
  20         dept.deptno     dept.dname
  21 ---------------------------------------------------------
  22         20      Sales
  23         30      IT
  24         40      Mkt
  25         50      HR
  26
  27 echo select * from emp,dept;
  28 ---------------------------------------------------------
  29         emp.eno emp.dno dept.deptno     dept.dname
  30 ---------------------------------------------------------
  31         1       10      20      Sales
  32         1       10      30      IT
  33         1       10      40      Mkt
  34         1       10      50      HR
  35         2       20      20      Sales
  36         2       20      30      IT
  37         2       20      40      Mkt
  38         2       20      50      HR
  39         4       40      20      Sales
  40         4       40      30      IT
  41         4       40      40      Mkt
  42         4       40      50      HR
  43
  44 echo select * from emp,dept where emp.dno between 10 and 30;
  45 ---------------------------------------------------------
  46         emp.eno emp.dno dept.deptno     dept.dname
  47 ---------------------------------------------------------
  48         1       10      20      Sales
  49         1       10      30      IT
  50         1       10      40      Mkt
  51         1       10      50      HR
  52         2       20      20      Sales
  53         2       20      30      IT
  54         2       20      40      Mkt
  55         2       20      50      HR
  56
  57 echo select * from emp,dept where dept.deptno between 20 and 40;
  58 ---------------------------------------------------------
  59         emp.eno emp.dno dept.deptno     dept.dname
  60 ---------------------------------------------------------
  61         1       10      20      Sales
  62         1       10      30      IT
  63         1       10      40      Mkt
  64         2       20      20      Sales
  65         2       20      30      IT
  66         2       20      40      Mkt
  67         4       40      20      Sales
  68         4       40      30      IT
  69         4       40      40      Mkt
  70
  71 echo select * from emp,dept where emp.dno between 15 and 30  and dept.deptno between 20 and 40;
  72 ---------------------------------------------------------
  73         emp.eno emp.dno dept.deptno     dept.dname
  74 ---------------------------------------------------------
  75         2       20      20      Sales
  76         2       20      30      IT
  77         2       20      40      Mkt
  78
  79 echo drop table emp;
  80 Statement Executed
  81 echo drop table dept;
  82 Statement Executed