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 inner
join t1 on t3.f1
= t1.f1
;
50 Statement prepare failed with error
-19
51 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 inner
join t1 on t3.f1
= t1.f1
;
52 Statement prepare failed with error
-19
53 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 inner
join t1 on t3.f1
= t1.f1
;
54 Statement prepare failed with error
-19
55 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 inner
join t1 on t3.f1
= t1.f1
;
56 Statement prepare failed with error
-19
57 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 inner
join t1 on t3.f1
= t1.f1
;
58 Statement prepare failed with error
-19
59 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 inner
join t1 on t3.f1
= t1.f1
;
60 Statement prepare failed with error
-19
61 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 inner
join t1 on t3.f1
= t1.f1
;
62 Statement prepare failed with error
-19
63 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 inner
join t1 on t3.f1
= t1.f1
;
64 Statement prepare failed with error
-19
65 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 inner
join t1 on t3.f1
= t1.f1
;
66 Statement prepare failed with error
-19