test/sql/Join/exp.test029.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;
  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         505     555     505     100     303     333
  33         505     555     505     100     101     110
  34         505     555     505     100     100     200
  35
  36 echo select * from t2,t1,t3 where t1.f1 = t2.f1;
  37 ---------------------------------------------------------
  38         t2.f1   t2.f2   t1.f1   t1.f2   t3.f1   t3.f2
  39 ---------------------------------------------------------
  40         505     100     505     555     303     333
  41         505     100     505     555     101     110
  42         505     100     505     555     100     200
  43         100     110     100     100     303     333
  44         100     110     100     100     101     110
  45         100     110     100     100     100     200
  46
  47 echo select * from t3,t1,t2 where t1.f1 = t2.f1;
  48 ---------------------------------------------------------
  49         t3.f1   t3.f2   t1.f1   t1.f2   t2.f1   t2.f2
  50 ---------------------------------------------------------
  51         303     333     100     100     100     110
  52         303     333     505     555     505     100
  53         101     110     100     100     100     110
  54         101     110     505     555     505     100
  55         100     200     100     100     100     110
  56         100     200     505     555     505     100
  57
  58 Statement Executed
  59 Statement Executed
  60 Statement Executed