-- Collection of code snippets by Arne Vajhøj 
-- (likely posted to comp.os.vms/INFO-VAX, INFO-TPU, MACRO32, eksperten.dk, newz.dk, LinkedIn or other place sometime between 1990 and now) 
CREATE TABLE x1 (
    id INTEGER NOT NULL AUTO_INCREMENT,
    v VARCHAR(32),
    PRIMARY KEY(id)
);
INSERT INTO x1(v) VALUES('A');
INSERT INTO x1(v) VALUES('B');
SELECT * FROM x1;
CREATE TABLE x2 (
    id INTEGER NOT NULL AUTO_INCREMENT,
    v VARCHAR(32),
    PRIMARY KEY(id)
);
INSERT INTO x2(v) VALUES('C');
INSERT INTO x2(v) VALUES('D');
SELECT * FROM x2;
INSERT INTO x1(v) SELECT v FROM x2;
SELECT * FROM x1;
DROP TABLE x1;
DROP TABLE x2;

