I would like to INSERT INTO TABLE_A SELECT * FROM TABLE_B, but, put fixed values into the first three columns of the destination table, as follows;
INSERT INTO TABLE_A
VALUES ("VAL1", "VAL2", "VAL3", ((Select X From TABLE_B))
Where "X" is the remaining columns from TABLE_B.
Obviously, this...