Lines Matching refs:t4
114 CREATE TABLE t4(a,b);
115 INSERT INTO t4 VALUES(NULL,'$long');
146 execsql {SELECT count(*),count(a),count(b) FROM t4}
149 execsql {SELECT count(*),count(a),count(b) FROM t4 WHERE b=5}
170 execsql {SELECT min(b), min(b) FROM t4}
602 DELETE FROM t4;
604 INSERT INTO t4 VALUES(3,4);
605 SELECT * FROM t3, t4;
610 SELECT * FROM t3, t4;
612 } {t3.a 1 t3.b 2 t4.a 3 t4.b 4}
615 SELECT * FROM t3 AS x, t4 AS y;
620 SELECT t3.*, t4.b FROM t3, t4;
625 SELECT "t3".*, t4.b FROM t3, t4;
630 SELECT t3.*, t4.b FROM t3, t4;
632 } {t3.a 1 t3.b 2 t4.b 4}
635 SELECT x.*, y.b FROM t3 AS x, t4 AS y;
640 SELECT t3.b, t4.* FROM t3, t4;
645 SELECT t3.b, t4.* FROM t3, t4;
647 } {t3.b 2 t4.a 3 t4.b 4}
650 SELECT x.b, y.* FROM t3 AS x, t4 AS y;
655 SELECT t5.* FROM t3, t4;
660 SELECT t3.* FROM t3 AS x, t4;
665 SELECT t3.* FROM t3, (SELECT max(a), max(b) FROM t4)
670 SELECT t3.* FROM (SELECT max(a), max(b) FROM t4), t3
675 SELECT * FROM t3, (SELECT max(a), max(b) FROM t4) AS 'tx'
680 SELECT y.*, t3.* FROM t3, (SELECT max(a), max(b) FROM t4) AS y
685 SELECT y.* FROM t3 as y, t4 as z
731 SELECT a,b FROM t3 UNION SELECT a AS 'x', b AS 'y' FROM t4 ORDER BY a,b
738 SELECT a,b FROM t3 UNION SELECT a AS 'x', b AS 'y' FROM t4 ORDER BY a,b