Lines Matching refs:LEFT

218     SELECT * FROM t1 NATURAL LEFT JOIN t2;
223     SELECT * FROM t2 NATURAL LEFT OUTER JOIN t1;
233     SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d
238     SELECT * FROM t1 LEFT JOIN t2 ON t1.a IS t2.d
243     SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d WHERE t1.a>1
248     SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d WHERE t2.b IS NULL OR t2.b>1
291     SELECT * FROM t1 LEFT BOGUS JOIN t2;
293 } {1 {unknown join type: LEFT BOGUS}}
375     SELECT coalesce(t8.a,999) from t7 LEFT JOIN t8 on y=a;
394     SELECT * FROM t9 LEFT JOIN v10_11 ON( a=x );
400       SELECT * FROM t9 LEFT JOIN (SELECT x, q FROM t10, t11 WHERE t10.y=t11.p)
407     SELECT * FROM v10_11 LEFT JOIN t9 ON( a=x );
412 # Ticket #350 describes a scenario where LEFT OUTER JOIN does not
416 # To test the problem, we generate the same LEFT OUTER JOIN in two
436       SELECT * FROM t12 NATURAL LEFT JOIN t13
438       SELECT * FROM t12 NATURAL LEFT JOIN (SELECT * FROM t13 WHERE b>0);
446       SELECT * FROM t12 NATURAL LEFT JOIN t13
448         SELECT * FROM t12 NATURAL LEFT JOIN v13;
458     SELECT a FROM t21 LEFT JOIN t22 ON b=p WHERE q=