test/sql/Join/exp.test031.ksh

   1 echo create table t1(f1 int,f2 int);
   2 Statement Executed
   3 echo create table t2(f1 int,f2 int);
   4 Statement Executed
   5 echo create table t3(f1 int,f2 int);
   6 Statement Executed
   7 echo insert into t1 values(101,100);
   8 Statement Executed: Rows Affected = 1
   9 echo insert into t1 values(303,333);
  10 Statement Executed: Rows Affected = 1
  11 echo insert into t1 values(505,555);
  12 Statement Executed: Rows Affected = 1
  13 echo insert into t2 values(505,100);
  14 Statement Executed: Rows Affected = 1
  15 echo insert into t2 values(404,444);
  16 Statement Executed: Rows Affected = 1
  17 echo insert into t2 values(101,110);
  18 Statement Executed: Rows Affected = 1
  19 echo insert into t3 values(303,333);
  20 Statement Executed: Rows Affected = 1
  21 echo insert into t3 values(101,110);
  22 Statement Executed: Rows Affected = 1
  23 echo insert into t3 values(222,200);
  24 Statement Executed: Rows Affected = 1
  25 echo select * from t1,t2,t3 where t1.f1 = t2.f1 and t2.f1=100;
  26 ---------------------------------------------------------
  27         t1.f1   t1.f2   t2.f1   t2.f2   t3.f1   t3.f2
  28 ---------------------------------------------------------
  29         100     100     100     110     303     333
  30         100     100     100     110     101     110
  31         100     100     100     110     100     200
  32
  33 echo select * from t2,t1,t3 where t1.f1 = t2.f1 and t2.f1=100;
  34 ---------------------------------------------------------
  35         t2.f1   t2.f2   t1.f1   t1.f2   t3.f1   t3.f2
  36 ---------------------------------------------------------
  37         100     110     100     100     303     333
  38         100     110     100     100     101     110
  39         100     110     100     100     100     200
  40
  41 echo select * from t3,t1,t2 where t1.f1 = t2.f1 and t2.f1=100;
  42 ---------------------------------------------------------
  43         t3.f1   t3.f2   t1.f1   t1.f2   t2.f1   t2.f2
  44 ---------------------------------------------------------
  45         303     333     100     100     100     110
  46         101     110     100     100     100     110
  47         100     200     100     100     100     110
  48
  49 Statement Executed
  50 Statement Executed
  51 Statement Executed