Up: SQLite [Top][Contents]
CREATE TABLE t(a, b); CREATE TABLE u(c, d); INSERT INTO t(a, b) VALUES (10, 20); INSERT INTO u(c, d) VALUES (30, 40); SELECT a, b, c, d FROM t JOIN u;