Lines Matching refs:t4
112 CREATE TABLE t4(a,b);
113 INSERT INTO t4 VALUES(NULL,'$long');
144 execsql {SELECT count(*),count(a),count(b) FROM t4}
147 execsql {SELECT count(*),count(a),count(b) FROM t4 WHERE b=5}
168 execsql {SELECT min(b), min(b) FROM t4}
600 DELETE FROM t4;
602 INSERT INTO t4 VALUES(3,4);
603 SELECT * FROM t3, t4;
608 SELECT * FROM t3, t4;
610 } {t3.a 1 t3.b 2 t4.a 3 t4.b 4}
613 SELECT * FROM t3 AS x, t4 AS y;
618 SELECT t3.*, t4.b FROM t3, t4;
623 SELECT "t3".*, t4.b FROM t3, t4;
628 SELECT t3.*, t4.b FROM t3, t4;
630 } {t3.a 1 t3.b 2 t4.b 4}
633 SELECT x.*, y.b FROM t3 AS x, t4 AS y;
638 SELECT t3.b, t4.* FROM t3, t4;
643 SELECT t3.b, t4.* FROM t3, t4;
645 } {t3.b 2 t4.a 3 t4.b 4}
648 SELECT x.b, y.* FROM t3 AS x, t4 AS y;
653 SELECT t5.* FROM t3, t4;
658 SELECT t3.* FROM t3 AS x, t4;
663 SELECT t3.* FROM t3, (SELECT max(a), max(b) FROM t4)
668 SELECT t3.* FROM (SELECT max(a), max(b) FROM t4), t3
673 SELECT * FROM t3, (SELECT max(a), max(b) FROM t4) AS 'tx'
678 SELECT y.*, t3.* FROM t3, (SELECT max(a), max(b) FROM t4) AS y
683 SELECT y.* FROM t3 as y, t4 as z
729 SELECT a,b FROM t3 UNION SELECT a AS 'x', b AS 'y' FROM t4 ORDER BY a,b
736 SELECT a,b FROM t3 UNION SELECT a AS 'x', b AS 'y' FROM t4 ORDER BY a,b