Lines Matching refs:LEFT

157     SELECT * FROM t1 NATURAL LEFT JOIN t2;
162     SELECT * FROM t2 NATURAL LEFT OUTER JOIN t1;
172     SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d
177     SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d WHERE t1.a>1
182     SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d WHERE t2.b IS NULL OR t2.b>1
223     SELECT * FROM t1 LEFT BOGUS JOIN t2;
225 } {1 {unknown or unsupported join type: LEFT BOGUS}}
327     SELECT coalesce(t8.a,999) from t7 LEFT JOIN t8 on y=a;
348     SELECT * FROM t9 LEFT JOIN v10_11 ON( a=x );
353     SELECT * FROM t9 LEFT JOIN (SELECT x, q FROM t10, t11 WHERE t10.y=t11.p)
359     SELECT * FROM v10_11 LEFT JOIN t9 ON( a=x );
363 # Ticket #350 describes a scenario where LEFT OUTER JOIN does not
367 # To test the problem, we generate the same LEFT OUTER JOIN in two
382     SELECT * FROM t12 NATURAL LEFT JOIN t13
384       SELECT * FROM t12 NATURAL LEFT JOIN (SELECT * FROM t13 WHERE b>0);
390     SELECT * FROM t12 NATURAL LEFT JOIN t13
392       SELECT * FROM t12 NATURAL LEFT JOIN v13;