Lines Matching refs:left

16 # This file implements tests for left outer joins containing WHERE
17 # clauses that restrict the scope of the left term of the join.
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'
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')