Lines Matching refs:ON
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
186 SELECT * FROM t1 NATURAL JOIN t2 ON t1.a=t2.b;
188 } {1 {a NATURAL join may not have an ON or USING clause}}
193 } {1 {a NATURAL join may not have an ON or USING clause}}
196 SELECT * FROM t1 JOIN t2 ON t1.a=t2.b USING(b);
198 } {1 {cannot have both ON and USING clauses in the same join}}
211 SELECT * FROM t1 JOIN t2 ON t3.a=t2.b;
346 SELECT * FROM t9 LEFT JOIN v10_11 ON( a=x );
352 ON( a=x);
357 SELECT * FROM v10_11 LEFT JOIN t9 ON( a=x );