Unanswered: SQL: INSERT INTO with VALUES *and* SELECT
Via INSERT INTO .... SELECT ... WHERE .... I managed to fill in missing entries in a table. Now I would like to fill in some other fields of those newly created entries - at the same time.... kind of a combination of SELECT *and* VALUES ()...
Does anybody know how to accomplish this?
This is how far I got:
INSERT INTO [tblB] SELECT [tblA].[ID] AS [ID] FROM [tblA] WHERE [ID] NOT IN (SELECT [ID] FROM [tblB]);
(I imagine some addition like ", ([strVariable]) VALUES ('Defaultvalue')")