1 echo create table t1
(f1 int
,f2 int
);
3 echo create table t2
(f1 int
,f2 int
);
5 echo create table t3
(f1 int
,f2 int
);
7 echo create index idx1 on t1
(f1
) tree
;
9 echo create index idx2 on t2
(f1
) tree
;
11 echo create index idx3 on t3
(f1
) tree
;
13 echo insert into t1 values
(101,100);
14 Statement Executed
: Rows Affected
= 1
15 echo insert into t1 values
(303,333);
16 Statement Executed
: Rows Affected
= 1
17 echo insert into t1 values
(505,555);
18 Statement Executed
: Rows Affected
= 1
19 echo insert into t2 values
(505,100);
20 Statement Executed
: Rows Affected
= 1
21 echo insert into t2 values
(404,444);
22 Statement Executed
: Rows Affected
= 1
23 echo insert into t2 values
(101,110);
24 Statement Executed
: Rows Affected
= 1
25 echo insert into t3 values
(303,333);
26 Statement Executed
: Rows Affected
= 1
27 echo insert into t3 values
(101,110);
28 Statement Executed
: Rows Affected
= 1
29 echo insert into t3 values
(222,200);
30 Statement Executed
: Rows Affected
= 1
31 echo select * from t1
,t2
,t3 where t1.f1
= t2.f1 and t2.f1
=100;
32 ---------------------------------------------------------
33 t1.f1 t1.f2 t2.f1 t2.f2 t3.f1 t3.f2
34 ---------------------------------------------------------
35 100 100 100 110 303 333
36 100 100 100 110 101 110
37 100 100 100 110 100 200
39 echo select * from t2
,t1
,t3 where t1.f1
= t2.f1 and t2.f1
=100;
40 ---------------------------------------------------------
41 t2.f1 t2.f2 t1.f1 t1.f2 t3.f1 t3.f2
42 ---------------------------------------------------------
43 100 110 100 100 303 333
44 100 110 100 100 101 110
45 100 110 100 100 100 200
47 echo select * from t3
,t1
,t2 where t1.f1
= t2.f1 and t2.f1
=100;
48 ---------------------------------------------------------
49 t3.f1 t3.f2 t1.f1 t1.f2 t2.f1 t2.f2
50 ---------------------------------------------------------
51 303 333 100 100 100 110
52 101 110 100 100 100 110
53 100 200 100 100 100 110