Lines Matching refs:USING
52 SELECT * FROM t1 INNER JOIN t2 USING(b,c);
57 SELECT * FROM t1 INNER JOIN t2 USING(b);
62 SELECT * FROM t1 INNER JOIN t2 USING(c);
67 SELECT * FROM t1 INNER JOIN t2 USING(c,b);
78 SELECT * FROM t1 CROSS JOIN t2 USING(b,c);
88 SELECT * FROM t1 INNER JOIN t2 USING(b,c);
188 } {1 {a NATURAL join may not have an ON or USING clause}}
191 SELECT * FROM t1 NATURAL JOIN t2 USING(b);
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}}
201 SELECT * FROM t1 JOIN t2 USING(a);
206 SELECT * FROM t1 USING(a);