Lines Matching refs:ok

31       insert into t2 values(2,'niban','ok');
35       select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
37   } {2 two 2 niban ok}
48       insert into t2 values(2,'niban','ok');
52       select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
54   } {2 two 2 niban ok}
58     select * from t1 left outer join t2 on t1.a=t2.x and t2.z='ok'
60 } {1 one {} {} {} 2 two 2 niban ok 3 three {} {} {} 4 four {} {} {}}
66     select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
68 } {2 two 2 niban ok}
71     select * from t1 left outer join t2 on t1.a=t2.x and t2.z='ok'
73 } {1 one {} {} {} 2 two 2 niban ok 3 three {} {} {} 4 four {} {} {}}
76     select * from t1 left outer join t2 on t1.a=t2.x where t2.z>='ok'
78 } {2 two 2 niban ok}
81     select * from t1 left outer join t2 on t1.a=t2.x and t2.z>='ok'
83 } {1 one {} {} {} 2 two 2 niban ok 3 three {} {} {} 4 four {} {} {}}
87       select * from t1 left outer join t2 on t1.a=t2.x where t2.z IN ('ok')
89   } {2 two 2 niban ok}
92       select * from t1 left outer join t2 on t1.a=t2.x and t2.z IN ('ok')
94   } {1 one {} {} {} 2 two 2 niban ok 3 three {} {} {} 4 four {} {} {}}