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 |
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 |