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
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
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
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
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
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 ---------------------------------------------------------
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 ---------------------------------------------------------
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
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 ---------------------------------------------------------
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 ---------------------------------------------------------
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 ---------------------------------------------------------
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
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 ---------------------------------------------------------
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