Lines Matching refs:USING
54 SELECT * FROM t1 INNER JOIN t2 USING(b,c);
59 SELECT * FROM t1 INNER JOIN t2 USING(b);
64 SELECT * FROM t1 INNER JOIN t2 USING(c);
69 SELECT * FROM t1 INNER JOIN t2 USING(c,b);
80 SELECT * FROM t1 CROSS JOIN t2 USING(b,c);
90 SELECT * FROM t1 INNER JOIN t2 USING(b,c);
190 } {1 {a NATURAL join may not have an ON or USING clause}}
193 SELECT * FROM t1 NATURAL JOIN t2 USING(b);
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}}
203 SELECT * FROM t1 JOIN t2 USING(a);
208 SELECT * FROM t1 USING(a);