Lines Matching refs:LEFT

13 # in cases that include a LEFT JOIN.
44     SELECT * FROM t1, t2 LEFT JOIN t3 ON q=x WHERE p=2 AND a=q;
50      explain_no_trace {SELECT * FROM t1, t2 LEFT JOIN t3 ON q=x
52   } [explain_no_trace {SELECT * FROM t1, t2 LEFT JOIN t3 ON x=q
58 # This is similar to the above but with the LEFT JOIN on the
84     LEFT OUTER JOIN child1 ON child1.child1key = parent1.child1key
94        LEFT OUTER JOIN child1 ON child1.child1key = parent1.child1key
100        LEFT OUTER JOIN child1 ON parent1.child1key = child1.child1key 
156     SELECT * FROM tA, tB, tC LEFT JOIN tD ON dpk=cx
162     SELECT * FROM tA, tB, tC LEFT JOIN tD ON cx=dpk
168     SELECT * FROM tA, tB, tC LEFT JOIN tD ON cx=dpk
174     SELECT * FROM tA, tB, tC LEFT JOIN tD ON cx=dpk
180     SELECT * FROM tA, tB, tC LEFT JOIN tD ON dpk=cx
186     SELECT * FROM tA, tB, tC LEFT JOIN tD ON dpk=cx
192     SELECT * FROM tA, tB, tC LEFT JOIN tD ON dpk=cx
198     SELECT * FROM tA, tB, tC LEFT JOIN tD ON dpk=cx
204     SELECT * FROM tA, tB, tC LEFT JOIN tD ON dpk=cx
210     SELECT * FROM tA, tB, tC LEFT JOIN tD ON dpk=cx
216     SELECT * FROM tA, tB, tC LEFT JOIN tD ON dpk=cx
222     SELECT * FROM tA, tB, tC LEFT JOIN tD ON dpk=cx
467     SELECT x1 FROM t71 LEFT JOIN t72 ON x2=y1;
470     SELECT x1 FROM t71 LEFT JOIN t72 ON x2=y1 WHERE y2 IS NULL;
473     SELECT x1 FROM t71 LEFT JOIN t72 ON x2=y1 WHERE y2 IS NOT NULL;
476     SELECT x1 FROM t71 LEFT JOIN t72 ON x2=y1 AND y2 IS NULL;
479     SELECT x1 FROM t71 LEFT JOIN t72 ON x2=y1 AND y2 IS NOT NULL;
482     SELECT x3 FROM t73 LEFT JOIN t72 ON x2=y3;
485     SELECT DISTINCT x3 FROM t73 LEFT JOIN t72 ON x2=y3;
488     SELECT x3 FROM t73 LEFT JOIN t74 ON x4=y3;
491     SELECT DISTINCT x3 FROM t73 LEFT JOIN t74 ON x4=y3;