Lines Matching refs:ON
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
188 SELECT * FROM t1 NATURAL JOIN t2 ON t1.a=t2.b;
190 } {1 {a NATURAL join may not have an ON or USING clause}}
195 } {1 {a NATURAL join may not have an ON or USING clause}}
198 SELECT * FROM t1 JOIN t2 ON t1.a=t2.b USING(b);
200 } {1 {cannot have both ON and USING clauses in the same join}}
213 SELECT * FROM t1 JOIN t2 ON t3.a=t2.b;
348 SELECT * FROM t9 LEFT JOIN v10_11 ON( a=x );
354 ON( a=x);
359 SELECT * FROM v10_11 LEFT JOIN t9 ON( a=x );