As vulpes said, when using Select in that format, you don't use values. Your SQL should be in the format:
INSERT INTO [DestinationTable] ([List], [of], [Column], [Names])
SELECT [List], [of], [Column], [Names]
FROM [SourceTable]
{WHERE...};