Lines Matching refs:LEFT

155     SELECT * FROM t1 NATURAL LEFT JOIN t2;
160     SELECT * FROM t2 NATURAL LEFT OUTER JOIN t1;
170     SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d
175     SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d WHERE t1.a>1
180     SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.d WHERE t2.b IS NULL OR t2.b>1
221     SELECT * FROM t1 LEFT BOGUS JOIN t2;
223 } {1 {unknown or unsupported join type: LEFT BOGUS}}
325     SELECT coalesce(t8.a,999) from t7 LEFT JOIN t8 on y=a;
346     SELECT * FROM t9 LEFT JOIN v10_11 ON( a=x );
351     SELECT * FROM t9 LEFT JOIN (SELECT x, q FROM t10, t11 WHERE t10.y=t11.p)
357     SELECT * FROM v10_11 LEFT JOIN t9 ON( a=x );
361 # Ticket #350 describes a scenario where LEFT OUTER JOIN does not
365 # To test the problem, we generate the same LEFT OUTER JOIN in two
380     SELECT * FROM t12 NATURAL LEFT JOIN t13
382       SELECT * FROM t12 NATURAL LEFT JOIN (SELECT * FROM t13 WHERE b>0);
388     SELECT * FROM t12 NATURAL LEFT JOIN t13
390       SELECT * FROM t12 NATURAL LEFT JOIN v13;