test/sql/Join/exp.test084.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 Statement Executed: Rows Affected = 1
  13 Statement Executed
  14 Statement Executed: Rows Affected = 1
  15 Statement Executed: Rows Affected = 1
  16 Statement Executed: Rows Affected = 1
  17 Statement Executed: Rows Affected = 1
  18 Statement Executed: Rows Affected = 1
  19 echo select * from t1;
  20 ---------------------------------------------------------
  21         t1.f1   t1.f2   t1.f3   t1.f4   t1.f5   t1.f6   t1.f7   t1.f8   t1.f9
  22 ---------------------------------------------------------
  23         10      100     1000    Bijay   1000.000000     100000.000000   2009/3/1        11:59:59.0      2009/3/1 11:59:59.0
  24         11      110     1100    Jitendr 2000.000000     200000.000000   2009/3/2        11:59:58.0      2009/3/2 11:59:59.0
  25         12      120     1000    Nihar   3000.000000     300000.000000   2009/3/3        11:59:57.0      2009/3/3 11:59:59.0
  26         13      130     1500    Kishor  4000.000000     400000.000000   2009/3/4        11:59:59.0      2009/3/4 11:59:59.0
  27         14      100     1000    Praba   5000.000000     500000.000000   2009/3/1        11:59:58.0      2009/3/1 11:59:59.0
  28
  29 echo select * from t2;
  30 ---------------------------------------------------------
  31         t2.f1   t2.f2   t2.f3   t2.f4   t2.f5   t2.f6   t2.f7   t2.f8   t2.f9
  32 ---------------------------------------------------------
  33         13      110     1100    Sanjit  6000.000000     600000.000000   2009/3/2        11:59:57.0      2009/3/2 11:59:59.0
  34         16      120     1000    Sanjay  6500.000000     700000.000000   2009/3/3        11:59:59.0      2009/3/3 11:59:59.0
  35         17      130     1100    Arindam 8000.000000     800000.000000   2009/3/4        11:59:58.0      2009/3/4 11:59:59.0
  36         10      100     1000    Bijay   9000.000000     900000.000000   2009/3/1        11:59:57.0      2009/3/1 11:59:59.0
  37         11      110     1100    Jitendr 1000.000000     100000.000000   2009/3/2        11:59:58.0      2009/3/2 11:59:59.0
  38
  39 echo select * from t3;
  40 ---------------------------------------------------------
  41         t3.f1   t3.f2   t3.f3   t3.f4   t3.f5   t3.f6   t3.f7   t3.f8   t3.f9
  42 ---------------------------------------------------------
  43         12      120     1000    Nihar   2000.000000     200000.000000   2009/3/3        11:59:56.0      2009/3/3 11:59:59.0
  44         13      130     1100    Kishor  3000.000000     300000.000000   2009/3/5        11:59:56.0      2009/3/5 11:59:59.0
  45         14      100     1000    Praba   4000.000000     400000.000000   2009/3/1        11:59:55.0      2009/3/4 11:59:59.0
  46         15      110     1100    Sanjit  5000.000000     500000.000000   2009/3/2        11:59:56.0      2009/3/1 11:59:59.0
  47         16      120     1000    Sanjay  6000.000000     600000.000000   2009/3/3        11:59:55.0      2009/3/3 11:59:59.0
  48
  49 echo select t1.f1, t1.f2, t2.f1, t2.f2, t3.f1, t3.f2 from t1 inner join t2 on t1.f1 = t2.f1 inner join t3 on t2.f1 = t3.f1;
  50 ---------------------------------------------------------
  51         t1.f1   t1.f2   t2.f1   t2.f2   t3.f1   t3.f2
  52 ---------------------------------------------------------
  53         13      130     13      110     13      130
  54
  55 echo select t1.f1, t1.f2, t2.f1, t2.f2, t3.f1, t3.f2 from t1 inner join t2 on t1.f2 = t2.f2 inner join t3 on t2.f2 = t3.f2;
  56 ---------------------------------------------------------
  57         t1.f1   t1.f2   t2.f1   t2.f2   t3.f1   t3.f2
  58 ---------------------------------------------------------
  59         10      100     10      100     14      100
  60         11      110     13      110     15      110
  61         11      110     11      110     15      110
  62         12      120     16      120     12      120
  63         12      120     16      120     16      120
  64         13      130     17      130     13      130
  65         14      100     10      100     14      100
  66
  67 echo select t1.f1, t1.f3, t2.f1, t2.f3, t3.f1, t3.f3 from t1 inner join t2 on t1.f3 = t2.f3 inner join t3 on t2.f3 = t3.f3;
  68 ---------------------------------------------------------
  69         t1.f1   t1.f3   t2.f1   t2.f3   t3.f1   t3.f3
  70 ---------------------------------------------------------
  71         10      1000    16      1000    12      1000
  72         10      1000    16      1000    14      1000
  73         10      1000    16      1000    16      1000
  74         10      1000    10      1000    12      1000
  75         10      1000    10      1000    14      1000
  76         10      1000    10      1000    16      1000
  77         11      1100    13      1100    13      1100
  78         11      1100    13      1100    15      1100
  79         11      1100    17      1100    13      1100
  80         11      1100    17      1100    15      1100
  81         11      1100    11      1100    13      1100
  82         11      1100    11      1100    15      1100
  83         12      1000    16      1000    12      1000
  84         12      1000    16      1000    14      1000
  85         12      1000    16      1000    16      1000
  86         12      1000    10      1000    12      1000
  87         12      1000    10      1000    14      1000
  88         12      1000    10      1000    16      1000
  89         14      1000    16      1000    12      1000
  90         14      1000    16      1000    14      1000
  91         14      1000    16      1000    16      1000
  92         14      1000    10      1000    12      1000
  93         14      1000    10      1000    14      1000
  94         14      1000    10      1000    16      1000
  95
  96 echo select t1.f1, t1.f4, t2.f1, t2.f4, t3.f1, t3.f4 from t1 inner join t2 on t1.f4 = t2.f4 inner join t3 on t2.f4 = t3.f4;
  97 ---------------------------------------------------------
  98         t1.f1   t1.f4   t2.f1   t2.f4   t3.f1   t3.f4
  99 ---------------------------------------------------------
 100
 101 echo select t1.f1, t1.f5, t2.f1, t2.f5, t3.f1, t3.f5 from t1 inner join t2 on t1.f5 = t2.f5 inner join t3 on t2.f5 = t3.f5;
 102 ---------------------------------------------------------
 103         t1.f1   t1.f5   t2.f1   t2.f5   t3.f1   t3.f5
 104 ---------------------------------------------------------
 105
 106 echo select t1.f1, t1.f6, t2.f1, t2.f6, t3.f1, t3.f6 from t1 inner join t2 on t1.f6 = t2.f6 inner join t3 on t2.f6 = t3.f6;
 107 ---------------------------------------------------------
 108         t1.f1   t1.f6   t2.f1   t2.f6   t3.f1   t3.f6
 109 ---------------------------------------------------------
 110
 111 echo select t1.f1, t1.f7, t2.f1, t2.f7, t3.f1, t3.f7 from t1 inner join t2 on t1.f7 = t2.f7 inner join t3 on t2.f7 = t3.f7;
 112 ---------------------------------------------------------
 113         t1.f1   t1.f7   t2.f1   t2.f7   t3.f1   t3.f7
 114 ---------------------------------------------------------
 115         10      2009/3/1        10      2009/3/1        14      2009/3/1
 116         11      2009/3/2        13      2009/3/2        15      2009/3/2
 117         11      2009/3/2        11      2009/3/2        15      2009/3/2
 118         12      2009/3/3        16      2009/3/3        12      2009/3/3
 119         12      2009/3/3        16      2009/3/3        16      2009/3/3
 120         14      2009/3/1        10      2009/3/1        14      2009/3/1
 121
 122 echo select t1.f1, t1.f8, t2.f1, t2.f8, t3.f1, t3.f8 from t1 inner join t2 on t1.f8 = t2.f8 inner join t3 on t2.f8 = t3.f8;
 123 ---------------------------------------------------------
 124         t1.f1   t1.f8   t2.f1   t2.f8   t3.f1   t3.f8
 125 ---------------------------------------------------------
 126
 127 echo select t1.f1, t1.f9, t2.f1, t2.f9, t3.f1, t3.f9 from t1 inner join t2 on t1.f9 = t2.f9 inner join t3 on t2.f9 = t3.f9;
 128 ---------------------------------------------------------
 129         t1.f1   t1.f9   t2.f1   t2.f9   t3.f1   t3.f9
 130 ---------------------------------------------------------
 131         10      2009/3/1 11:59:59.0     10      2009/3/1 11:59:59.0     15      2009/3/1 11:59:59.0
 132         12      2009/3/3 11:59:59.0     16      2009/3/3 11:59:59.0     12      2009/3/3 11:59:59.0
 133         12      2009/3/3 11:59:59.0     16      2009/3/3 11:59:59.0     16      2009/3/3 11:59:59.0
 134         13      2009/3/4 11:59:59.0     17      2009/3/4 11:59:59.0     14      2009/3/4 11:59:59.0
 135         14      2009/3/1 11:59:59.0     10      2009/3/1 11:59:59.0     15      2009/3/1 11:59:59.0
 136
 137 Statement Executed
 138 Statement Executed
 139 Statement Executed