Lines Matching refs:t2

30       create temp table t2(x integer, y varchar(10), z varchar(10));
31       insert into t2 values(2,'niban','ok');
32       insert into t2 values(4,'yonban','err');
35       select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
47       create table t2(x integer, y varchar(10), z varchar(10));
48       insert into t2 values(2,'niban','ok');
49       insert into t2 values(4,'yonban','err');
52       select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
58     select * from t1 left outer join t2 on t1.a=t2.x and t2.z='ok'
63     create index i2 on t2(z);
66     select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
71     select * from t1 left outer join t2 on t1.a=t2.x and t2.z='ok'
76     select * from t1 left outer join t2 on t1.a=t2.x where t2.z>='ok'
81     select * from t1 left outer join t2 on t1.a=t2.x and t2.z>='ok'
87       select * from t1 left outer join t2 on t1.a=t2.x where t2.z IN ('ok')
92       select * from t1 left outer join t2 on t1.a=t2.x and t2.z IN ('ok')