SQL select only specific fields and insert them in another table + static values

Question

I would like to insert data from specific fields from one table in another table + some static values. Roughly I would like to do this:

INSERT INTO TableA(Field1, Field2, Field3) 
SELECT Field1, Field2, 'staticvalue', Field3
FROM TableB
WHERE TableB.Field6 = 'XYZ'

Any idea how can I mix both specific fields from one table and static values?

possible duplicate of Stored procedure for inserting a constant plus values from another table — Tab Alleman
– Tab Alleman, Commented Oct 23, 2014 at 17:52

Dave C · Accepted Answer · 2014-10-23 17:45:51Z

2

You're on the right track... you need to supply a column for the static value to be inserted into.

INSERT INTO TableA(Field1, Field2, someOtherField, Field3) 
SELECT Field1, Field2, 'staticvalue', Field3
FROM TableB
WHERE TableB.Field6 = 'XYZ'

answered Oct 23, 2014 at 17:45

Dave C

7,4821 gold badge21 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1