Lines Matching refs:r

89     SELECT q, p, r
91          (SELECT max(x) as r, y as s FROM t1 GROUP BY y) as b
97     SELECT q, p, r, b.[min(x)+y]
99          (SELECT max(x) as r, y as s, min(x)+y FROM t1 GROUP BY y) as b
145     SELECT q, p, r
147          (SELECT max(a) as r, b as s FROM t2 GROUP BY b) as b
153     SELECT a.q, a.p, b.r
155          (SELECT max(a) as r, b as s FROM t2 GROUP BY s) as b
168       (SELECT a.q, a.p, b.r
170             (SELECT max(a) as r, b as s FROM t2 GROUP BY s) as b
395     CREATE TABLE t4(q,r);
404     SELECT y, p, q, r FROM
406        (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
415     SELECT y, p, q, r FROM
417        (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
424     SELECT DISTINCT y, p, q, r FROM
426        (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
433       (SELECT y, p, q, r FROM
435          (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
437       (SELECT r AS z FROM t4 WHERE q=11) AS f
438     WHERE e.r=f.z
445       (SELECT y, p, q, r FROM
447          (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
449       (SELECT r AS z FROM t4 WHERE q=11) AS f
450     WHERE e.r=f.z