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
: 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 Statement Executed
: Rows Affected
= 1
20 Statement Executed
: Rows Affected
= 1
21 Statement Executed
: Rows Affected
= 1
22 Statement Executed
: Rows Affected
= 1
23 Statement Executed
: Rows Affected
= 1
24 Statement Executed
: Rows Affected
= 1
26 Statement Executed
: Rows Affected
= 1
27 Statement Executed
: Rows Affected
= 1
28 Statement Executed
: Rows Affected
= 1
29 Statement Executed
: Rows Affected
= 1
30 Statement Executed
: Rows Affected
= 1
31 Statement Executed
: Rows Affected
= 1
32 Statement Executed
: Rows Affected
= 1
33 Statement Executed
: Rows Affected
= 1
34 Statement Executed
: Rows Affected
= 1
35 Statement Executed
: Rows Affected
= 1
36 Statement Executed
: Rows Affected
= 1
37 echo SELECT
* FROM t1
;
38 ---------------------------------------------------------
39 t1.f1 t1.f2 t1.f3 t1.f4
40 ---------------------------------------------------------
41 3 AAA
2.500000 2008/7/1
42 2 AAA
2.500000 2008/7/2
43 4 GGG
4.500000 2008/7/3
44 1 DEF
1.500000 2008/7/1
45 6 CCC
6.500000 2008/7/2
46 5 HHH
5.500000 2008/7/3
47 2 AAA
2.500000 2008/7/1
48 6 CCC
6.500000 2008/7/4
49 3 ABB
2.600000 2008/7/5
50 2 BBB
1.600000 2008/7/4
51 1 DDD
1.600000 2008/7/1
53 echo SELECT
* FROM t2
;
54 ---------------------------------------------------------
55 t2.f1 t2.f2 t2.f3 t2.f4
56 ---------------------------------------------------------
57 1 DEF
1.500000 2008/7/1
58 9 QQQ
9.500000 2008/7/2
59 3 MMM
2.500000 2008/7/3
60 4 GGG
4.600000 2008/7/1
61 7 PPP
7.500000 2008/7/2
62 8 NNN
8.500000 2008/7/3
63 9 QQQ
9.500000 2008/7/1
64 8 AAA
8.500000 2008/7/4
65 7 AAA
7.500000 2008/7/5
66 9 BBB
9.800000 2008/7/4
67 8 EEE
8.800000 2008/7/1
69 echo SELECT
* FROM t3
;
70 ---------------------------------------------------------
71 t3.f1 t3.f2 t3.f3 t3.f4
72 ---------------------------------------------------------
73 1 DEF
1.500000 2008/7/1
74 2 AAA
2.500000 2008/7/2
75 7 PPP
7.500000 2008/7/3
76 8 NNN
8.500000 2008/7/4
77 9 QQQ
9.500000 2008/7/1
78 10 NNN
10.500000 2008/7/2
79 1 DEF
1.500000 2008/7/3
80 2 AAA
2.500000 2008/7/4
81 7 PPP
7.500000 2008/7/1
82 8 NNN
8.500000 2008/7/2
83 10 NNN
10.500000 2008/7/4
85 echo SELECT
* FROM t1 INNER JOIN t2 ON t1.f1
= t2.f1 ORDER BY t1.f1
;
86 ---------------------------------------------------------
87 t1.f1 t1.f2 t1.f3 t1.f4 t2.f1 t2.f2 t2.f3 t2.f4
88 ---------------------------------------------------------
89 1 DDD
1.600000 2008/7/1 1 DEF
1.500000 2008/7/1
90 1 DEF
1.500000 2008/7/1 1 DEF
1.500000 2008/7/1
91 3 ABB
2.600000 2008/7/5 3 MMM
2.500000 2008/7/3
92 3 AAA
2.500000 2008/7/1 3 MMM
2.500000 2008/7/3
93 4 GGG
4.500000 2008/7/3 4 GGG
4.600000 2008/7/1
95 echo SELECT t1.f1
, t2.f1
, t3.f1 FROM t1 INNER JOIN t2 ON t1.f1
= t2.f1 INNER JOIN t3 ON t2.f1
= t3.f1 ORDER BY t1.f1
;
96 ---------------------------------------------------------
98 ---------------------------------------------------------
104 echo SELECT
* FROM t1 INNER JOIN t2 ON t1.f1
= t2.f1 ORDER BY t1.f1
,t2.f1
;
105 ---------------------------------------------------------
106 t1.f1 t1.f2 t1.f3 t1.f4 t2.f1 t2.f2 t2.f3 t2.f4
107 ---------------------------------------------------------
108 1 DDD
1.600000 2008/7/1 1 DEF
1.500000 2008/7/1
109 1 DEF
1.500000 2008/7/1 1 DEF
1.500000 2008/7/1
110 3 ABB
2.600000 2008/7/5 3 MMM
2.500000 2008/7/3
111 3 AAA
2.500000 2008/7/1 3 MMM
2.500000 2008/7/3
112 4 GGG
4.500000 2008/7/3 4 GGG
4.600000 2008/7/1
114 echo SELECT t1.f1
, t3.f1
, t2.f1 FROM t1 INNER JOIN t2 ON t1.f1
= t2.f1 INNER JOIN t3 ON t3.f1
= t1.f1 ORDER BY t1.f1
,t3.f1
,t2.f1
;
115 ---------------------------------------------------------
117 ---------------------------------------------------------
123 echo SELECT t1.f1
, t3.f1
, t2.f1 FROM t1 INNER JOIN t2 ON t1.f1
= t2.f1 INNER JOIN t3 ON t3.f1
= t1.f1 ORDER BY t1.f1 DESC
,t3.f1 DESC
,t2.f1 DESC
;
124 ---------------------------------------------------------
126 ---------------------------------------------------------
132 echo SELECT t1.f1
, t2.f1
, t1.f4
, t2.f4 FROM t1 INNER JOIN t2 ON t1.f1
< 2 OR t1.f3
< 2.5 ORDER BY t1.f4
, t2.f4
;
133 ---------------------------------------------------------
134 t1.f1 t2.f1 t1.f4 t2.f4
135 ---------------------------------------------------------
136 1 8 2008/7/1 2008/7/1
137 1 9 2008/7/1 2008/7/1
138 1 4 2008/7/1 2008/7/1
139 1 1 2008/7/1 2008/7/1
140 1 8 2008/7/1 2008/7/1
141 1 9 2008/7/1 2008/7/1
142 1 4 2008/7/1 2008/7/1
143 1 1 2008/7/1 2008/7/1
144 1 7 2008/7/1 2008/7/2
145 1 9 2008/7/1 2008/7/2
146 1 7 2008/7/1 2008/7/2
147 1 9 2008/7/1 2008/7/2
148 1 8 2008/7/1 2008/7/3
149 1 3 2008/7/1 2008/7/3
150 1 8 2008/7/1 2008/7/3
151 1 3 2008/7/1 2008/7/3
152 1 9 2008/7/1 2008/7/4
153 1 8 2008/7/1 2008/7/4
154 1 9 2008/7/1 2008/7/4
155 1 8 2008/7/1 2008/7/4
156 1 7 2008/7/1 2008/7/5
157 1 7 2008/7/1 2008/7/5
158 2 8 2008/7/4 2008/7/1
159 2 9 2008/7/4 2008/7/1
160 2 4 2008/7/4 2008/7/1
161 2 1 2008/7/4 2008/7/1
162 2 7 2008/7/4 2008/7/2
163 2 9 2008/7/4 2008/7/2
164 2 8 2008/7/4 2008/7/3
165 2 3 2008/7/4 2008/7/3
166 2 9 2008/7/4 2008/7/4
167 2 8 2008/7/4 2008/7/4
168 2 7 2008/7/4 2008/7/5
170 echo SELECT t1.f1
, t2.f1
, t1.f4
, t2.f4 FROM t1 INNER JOIN t2 ON t1.f1
< 2 OR t1.f3
< 2.5 ORDER BY t1.f1
, t1.f4 DESC
;
171 ---------------------------------------------------------
172 t1.f1 t2.f1 t1.f4 t2.f4
173 ---------------------------------------------------------
174 1 8 2008/7/1 2008/7/1
175 1 9 2008/7/1 2008/7/4
176 1 7 2008/7/1 2008/7/5
177 1 8 2008/7/1 2008/7/4
178 1 9 2008/7/1 2008/7/1
179 1 8 2008/7/1 2008/7/3
180 1 7 2008/7/1 2008/7/2
181 1 4 2008/7/1 2008/7/1
182 1 3 2008/7/1 2008/7/3
183 1 9 2008/7/1 2008/7/2
184 1 1 2008/7/1 2008/7/1
185 1 8 2008/7/1 2008/7/1
186 1 9 2008/7/1 2008/7/4
187 1 7 2008/7/1 2008/7/5
188 1 8 2008/7/1 2008/7/4
189 1 9 2008/7/1 2008/7/1
190 1 8 2008/7/1 2008/7/3
191 1 7 2008/7/1 2008/7/2
192 1 4 2008/7/1 2008/7/1
193 1 3 2008/7/1 2008/7/3
194 1 9 2008/7/1 2008/7/2
195 1 1 2008/7/1 2008/7/1
196 2 8 2008/7/4 2008/7/1
197 2 9 2008/7/4 2008/7/4
198 2 7 2008/7/4 2008/7/5
199 2 8 2008/7/4 2008/7/4
200 2 9 2008/7/4 2008/7/1
201 2 8 2008/7/4 2008/7/3
202 2 7 2008/7/4 2008/7/2
203 2 4 2008/7/4 2008/7/1
204 2 3 2008/7/4 2008/7/3
205 2 9 2008/7/4 2008/7/2
206 2 1 2008/7/4 2008/7/1
208 echo SELECT t1.f1
, t2.f4
, t2.f1 FROM t1 INNER JOIN t2 ON t1.f1
< 2 OR t2.f1
< 2 ORDER BY t1.f1
, t2.f4
;
209 ---------------------------------------------------------
211 ---------------------------------------------------------
244 echo SELECT t1.f1
, t2.f4
, t2.f1 FROM t1 INNER JOIN t2 ON t1.f1
< 2 OR t2.f1
< 2 ORDER BY t1.f1 DESC
, t2.f4
;
245 ---------------------------------------------------------
247 ---------------------------------------------------------