Lines Matching refs:ok
33 insert into t2 values(2,'niban','ok');
37 select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
39 } {2 two 2 niban ok}
42 select * from t1 left outer join t2 on t1.a=t2.x and t2.z='ok'
44 } {1 one {} {} {} 2 two 2 niban ok 3 three {} {} {} 4 four {} {} {}}
50 select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
52 } {2 two 2 niban ok}
55 select * from t1 left outer join t2 on t1.a=t2.x and t2.z='ok'
57 } {1 one {} {} {} 2 two 2 niban ok 3 three {} {} {} 4 four {} {} {}}
60 select * from t1 left outer join t2 on t1.a=t2.x where t2.z>='ok'
62 } {2 two 2 niban ok}
65 select * from t1 left outer join t2 on t1.a=t2.x and t2.z>='ok'
67 } {1 one {} {} {} 2 two 2 niban ok 3 three {} {} {} 4 four {} {} {}}
70 select * from t1 left outer join t2 on t1.a=t2.x where t2.z IN ('ok')
72 } {2 two 2 niban ok}
75 select * from t1 left outer join t2 on t1.a=t2.x and t2.z IN ('ok')
77 } {1 one {} {} {} 2 two 2 niban ok 3 three {} {} {} 4 four {} {} {}}