test/sql/Join/exp.test013.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 in(20,30);
  45 ---------------------------------------------------------
  46         emp.eno emp.dno dept.deptno     dept.dname
  47 ---------------------------------------------------------
  48         2       20      20      Sales
  49         2       20      30      IT
  50         2       20      40      Mkt
  51         2       20      50      HR
  52
  53 echo select * from emp,dept where dept.deptno in(20,30);
  54 ---------------------------------------------------------
  55         emp.eno emp.dno dept.deptno     dept.dname
  56 ---------------------------------------------------------
  57         1       10      20      Sales
  58         1       10      30      IT
  59         2       20      20      Sales
  60         2       20      30      IT
  61         4       40      20      Sales
  62         4       40      30      IT
  63
  64 echo select * from emp,dept where emp.dno in(20,30)  and dept.deptno in(20,30);
  65 ---------------------------------------------------------
  66         emp.eno emp.dno dept.deptno     dept.dname
  67 ---------------------------------------------------------
  68         2       20      20      Sales
  69         2       20      30      IT
  70
  71 echo select * from emp,dept where emp.dno in(20,30) or dept.deptno in(20,30);
  72 ---------------------------------------------------------
  73         emp.eno emp.dno dept.deptno     dept.dname
  74 ---------------------------------------------------------
  75         1       10      20      Sales
  76         1       10      30      IT
  77         2       20      20      Sales
  78         2       20      30      IT
  79         2       20      40      Mkt
  80         2       20      50      HR
  81         4       40      20      Sales
  82         4       40      30      IT
  83
  84 echo drop table emp;
  85 Statement Executed
  86 echo drop table dept;
  87 Statement Executed