Personal website Rudolf Adamkovič

Home / SQLite


Example: Merging tables column-wise

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;
a b c d
10 20 30 40

© 2025 Rudolf Adamkovič under GNU General Public License version 3.
Made with Emacs and secret alien technologies of yesteryear.