I have two tables with the same columns.
Table 1
Structure, Name, Active
1,A,1
Table 2
Structure, Name, Active
2,B,0
I want to combine these two tables and save them into a new one
New Table
Structure, Name, Active
1,A,1
2,B,0
Here is the code I came up with:
CREATE TABLE Amide_actives_decoys
(
Structure NVARCHAR(255),
Name NVARCHAR(255),
Active INT
)
GO
INSERT Amide_actives_decoys
FROM (
SELECT * FROM Amide_decoys
UNION
SELECT * FROM Amide_actives
)
But the following error message shows up:
Msg 156, Level 15, State 1, Line 10
Incorrect syntax near the keyword 'FROM'.
Can someone please help me with this?