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 130 1500 Kishor
4000.000000 400000.000000 2009/3/4 11:59:59.0 2009/3/4 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 10 100 1000 Bijay
1000.000000 100000.000000 2009/3/1 11:59:59.0 2009/3/1 11:59:59.0
36 17 130 1100 Arindam
8000.000000 800000.000000 2009/3/4 11:59:58.0 2009/3/4 11:59:59.0
37 11 110 1100 Jitendr
2000.000000 200000.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
3000.000000 300000.000000 2009/3/3 11:59:57.0 2009/3/3 11:59:59.0
44 14 100 1000 Praba
4000.000000 400000.000000 2009/3/1 11:59:55.0 2009/3/4 11:59:59.0
45 13 130 1500 Kishor
4000.000000 400000.000000 2009/3/4 11:59:59.0 2009/3/4 11:59:59.0
46 11 110 1100 Jitendr
2000.000000 200000.000000 2009/3/2 11:59:58.0 2009/3/2 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 distinct t1.f1
, t2.f1 from t1 inner
join t2 on t1.f1
= t2.f1
;
50 ---------------------------------------------------------
52 ---------------------------------------------------------
57 echo select distinct t1.f2
, t2.f2 from t1 inner
join t2 on t1.f2
= t2.f2
;
58 ---------------------------------------------------------
60 ---------------------------------------------------------
66 echo select distinct t1.f3
, t2.f3 from t1 inner
join t2 on t1.f3
= t2.f3
;
67 ---------------------------------------------------------
69 ---------------------------------------------------------
74 echo select distinct t1.f4
, t2.f4 from t1 inner
join t2 on t1.f4
= t2.f4
;
75 ---------------------------------------------------------
77 ---------------------------------------------------------
82 echo select distinct t1.f5
, t2.f5 from t1 inner
join t2 on t1.f5
= t2.f5
;
83 ---------------------------------------------------------
85 ---------------------------------------------------------
86 1000.000000 1000.000000
87 2000.000000 2000.000000
88 4000.000000 4000.000000
90 echo select distinct t1.f6
, t2.f6 from t1 inner
join t2 on t1.f6
= t2.f6
;
91 ---------------------------------------------------------
93 ---------------------------------------------------------
94 100000.000000 100000.000000
95 200000.000000 200000.000000
96 400000.000000 400000.000000
98 echo select distinct t1.f7
, t2.f7 from t1 inner
join t2 on t1.f7
= t2.f7
;
99 ---------------------------------------------------------
101 ---------------------------------------------------------
107 echo select distinct t1.f8
, t2.f8 from t1 inner
join t2 on t1.f8
= t2.f8
;
108 ---------------------------------------------------------
110 ---------------------------------------------------------
111 11:59:59.0 11:59:59.0
112 11:59:58.0 11:59:58.0
114 echo select distinct t1.f9
, t2.f9 from t1 inner
join t2 on t1.f9
= t2.f9
;
115 ---------------------------------------------------------
117 ---------------------------------------------------------
118 2009/3/1 11:59:59.0 2009/3/1 11:59:59.0
119 2009/3/2 11:59:59.0 2009/3/2 11:59:59.0
120 2009/3/3 11:59:59.0 2009/3/3 11:59:59.0
121 2009/3/4 11:59:59.0 2009/3/4 11:59:59.0
123 echo select distinct t1.f1
, t1.f2 from t1 inner
join t2 on t1.f1
= t2.f1
;
124 ---------------------------------------------------------
126 ---------------------------------------------------------
131 echo select distinct t1.f1
, t1.f2 from t1 inner
join t2 on t1.f2
= t2.f2
;
132 ---------------------------------------------------------
134 ---------------------------------------------------------
141 echo select distinct t1.f1
, t1.f3 from t1 inner
join t2 on t1.f3
= t2.f3
;
142 ---------------------------------------------------------
144 ---------------------------------------------------------
151 echo select distinct t1.f1
, t1.f4 from t1 inner
join t2 on t1.f4
= t2.f4
;
152 ---------------------------------------------------------
154 ---------------------------------------------------------
159 echo select distinct t1.f1
, t1.f5 from t1 inner
join t2 on t1.f5
= t2.f5
;
160 ---------------------------------------------------------
162 ---------------------------------------------------------
167 echo select distinct t1.f1
, t1.f6 from t1 inner
join t2 on t1.f6
= t2.f6
;
168 ---------------------------------------------------------
170 ---------------------------------------------------------
175 echo select distinct t1.f1
, t1.f7 from t1 inner
join t2 on t1.f7
= t2.f7
;
176 ---------------------------------------------------------
178 ---------------------------------------------------------
185 echo select distinct t1.f1
, t1.f8 from t1 inner
join t2 on t1.f8
= t2.f8
;
186 ---------------------------------------------------------
188 ---------------------------------------------------------
194 echo select distinct t1.f1
, t1.f9 from t1 inner
join t2 on t1.f9
= t2.f9
;
195 ---------------------------------------------------------
197 ---------------------------------------------------------
198 10 2009/3/1 11:59:59.0
199 11 2009/3/2 11:59:59.0
200 12 2009/3/3 11:59:59.0
201 13 2009/3/4 11:59:59.0
202 14 2009/3/1 11:59:59.0
204 echo select distinct t1.f1
, t1.f2
, t2.f1
, t2.f2 from t1 inner
join t2 on t1.f1
= t2.f1
;
205 ---------------------------------------------------------
206 t1.f1 t1.f2 t2.f1 t2.f2
207 ---------------------------------------------------------
212 echo select distinct t1.f1
, t1.f2
, t2.f1
, t2.f2 from t1 inner
join t2 on t1.f2
= t2.f2
;
213 ---------------------------------------------------------
214 t1.f1 t1.f2 t2.f1 t2.f2
215 ---------------------------------------------------------
223 echo select distinct t1.f1
, t1.f3
, t2.f1
, t2.f3 from t1 inner
join t2 on t1.f3
= t2.f3
;
224 ---------------------------------------------------------
225 t1.f1 t1.f3 t2.f1 t2.f3
226 ---------------------------------------------------------
237 echo select distinct t1.f1
, t1.f4
, t2.f1
, t2.f4 from t1 inner
join t2 on t1.f4
= t2.f4
;
238 ---------------------------------------------------------
239 t1.f1 t1.f4 t2.f1 t2.f4
240 ---------------------------------------------------------
242 11 Jitendr
11 Jitendr
245 echo select distinct t1.f1
, t1.f5
, t2.f1
, t2.f5 from t1 inner
join t2 on t1.f5
= t2.f5
;
246 ---------------------------------------------------------
247 t1.f1 t1.f5 t2.f1 t2.f5
248 ---------------------------------------------------------
249 10 1000.000000 10 1000.000000
250 11 2000.000000 11 2000.000000
251 13 4000.000000 13 4000.000000
253 echo select distinct t1.f1
, t1.f6
, t2.f1
, t2.f6 from t1 inner
join t2 on t1.f6
= t2.f6
;
254 ---------------------------------------------------------
255 t1.f1 t1.f6 t2.f1 t2.f6
256 ---------------------------------------------------------
257 10 100000.000000 10 100000.000000
258 11 200000.000000 11 200000.000000
259 13 400000.000000 13 400000.000000
261 echo select distinct t1.f1
, t1.f7
, t2.f1
, t2.f7 from t1 inner
join t2 on t1.f7
= t2.f7
;
262 ---------------------------------------------------------
263 t1.f1 t1.f7 t2.f1 t2.f7
264 ---------------------------------------------------------
265 10 2009/3/1 10 2009/3/1
266 11 2009/3/2 11 2009/3/2
267 12 2009/3/3 16 2009/3/3
268 13 2009/3/4 13 2009/3/4
269 13 2009/3/4 17 2009/3/4
270 14 2009/3/1 10 2009/3/1
272 echo select distinct t1.f1
, t1.f8
, t2.f1
, t2.f8 from t1 inner
join t2 on t1.f8
= t2.f8
;
273 ---------------------------------------------------------
274 t1.f1 t1.f8 t2.f1 t2.f8
275 ---------------------------------------------------------
276 10 11:59:59.0 13 11:59:59.0
277 10 11:59:59.0 16 11:59:59.0
278 10 11:59:59.0 10 11:59:59.0
279 11 11:59:58.0 17 11:59:58.0
280 11 11:59:58.0 11 11:59:58.0
281 13 11:59:59.0 13 11:59:59.0
282 13 11:59:59.0 16 11:59:59.0
283 13 11:59:59.0 10 11:59:59.0
284 14 11:59:58.0 17 11:59:58.0
285 14 11:59:58.0 11 11:59:58.0
287 echo select distinct t1.f1
, t1.f9
, t2.f1
, t2.f9 from t1 inner
join t2 on t1.f9
= t2.f9
;
288 ---------------------------------------------------------
289 t1.f1 t1.f9 t2.f1 t2.f9
290 ---------------------------------------------------------
291 10 2009/3/1 11:59:59.0 10 2009/3/1 11:59:59.0
292 11 2009/3/2 11:59:59.0 11 2009/3/2 11:59:59.0
293 12 2009/3/3 11:59:59.0 16 2009/3/3 11:59:59.0
294 13 2009/3/4 11:59:59.0 13 2009/3/4 11:59:59.0
295 13 2009/3/4 11:59:59.0 17 2009/3/4 11:59:59.0
296 14 2009/3/1 11:59:59.0 10 2009/3/1 11:59:59.0