Lines Matching refs:t2
32 create temp table t2(x integer, y varchar(10), z varchar(10));
33 insert into t2 values(2,'niban','ok');
34 insert into t2 values(4,'yonban','err');
37 select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
42 select * from t1 left outer join t2 on t1.a=t2.x and t2.z='ok'
47 create index i2 on t2(z);
50 select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
55 select * from t1 left outer join t2 on t1.a=t2.x and t2.z='ok'
60 select * from t1 left outer join t2 on t1.a=t2.x where t2.z>='ok'
65 select * from t1 left outer join t2 on t1.a=t2.x and t2.z>='ok'
70 select * from t1 left outer join t2 on t1.a=t2.x where t2.z IN ('ok')
75 select * from t1 left outer join t2 on t1.a=t2.x and t2.z IN ('ok')