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'
40 select * from t1 left outer join t2 on t1.a=t2.x and t2.z='ok'
45 create index i2 on t2(z);
48 select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
53 select * from t1 left outer join t2 on t1.a=t2.x and t2.z='ok'
58 select * from t1 left outer join t2 on t1.a=t2.x where t2.z>='ok'
63 select * from t1 left outer join t2 on t1.a=t2.x and t2.z>='ok'
68 select * from t1 left outer join t2 on t1.a=t2.x where t2.z IN ('ok')
73 select * from t1 left outer join t2 on t1.a=t2.x and t2.z IN ('ok')