I have a table (LINKS) where I want to create new records based upon old records. But some of the fields I want to change.
So from LINKS I want to auto populate with ENT_ID_1, ENT_TYP_1, ENT_TYP_2, but I want to make ENT_ID_2=185, and UPDATE_WHO=177 based upon WHERE ID in (1, 5, 12).
I know I can do the query below. But where do I fit my UPDATE_WHO & ENT_ID_2 fields in?
INSERT INTO Links(ENT_ID_1, ENT_TYP_1, ENT_TYP_2)
SELECT ENT_ID_1, ENT_TYP_1, ENT_TYP_2
WHERE ID in (1, 5, 12