Lines Matching refs:a2
933 CREATE TABLE a2(one PRIMARY KEY, three);
934 INSERT INTO a2 VALUES(1, 1);
935 INSERT INTO a2 VALUES(3, 2);
936 INSERT INTO a2 VALUES(6, 3);
937 INSERT INTO a2 VALUES(10, 4);
943 4 "SELECT *, count(*) FROM a1 JOIN a2" {1 1 1 1 16}
944 5 "SELECT *, sum(three) FROM a1 NATURAL JOIN a2" {1 1 1 3}
945 6 "SELECT *, sum(three) FROM a1 NATURAL JOIN a2" {1 1 1 3}
946 7 "SELECT group_concat(three, ''), a1.* FROM a1 NATURAL JOIN a2" {12 1 1}
955 2 "SELECT sum(two), * FROM a1, a2 WHERE three>5" {{} {} {} {} {}}
969 8.4 "SELECT max(a1.one)+min(two), a1.one, two, * FROM a1, a2 WHERE 1"
970 8.5 "SELECT max(a1.one)+min(two), a1.one, two, * FROM a1, a2 WHERE 0"