1
CREATE TABLE t1 (t1i int);
2
CREATE TABLE t2 (t2i int);
3
CREATE TABLE t3 (t3i int);
4
CREATE TABLE t4 (t4i int);
6
INSERT INTO t1 VALUES (1); # Note: t1 must be const table
7
INSERT INTO t2 VALUES (1),(2);
8
INSERT INTO t3 VALUES (1),(2);
9
INSERT INTO t4 VALUES (1),(2);
13
FROM t1 JOIN t4 ON t1i=t4i
24
DROP TABLE t1,t2,t3,t4;