#1136 - Column count doesn't match value count at row 1

[alias47]

I'm getting the above error with the following SQL Statement.  I cannot seem to find the error in the code.  The select statement does pull multiple rows.

I'm using my SQL version:  4.1.19

Any clue on why this isn't working?
Thanks,

INSERT INTO `Grants` ( `Project_Code` , `Grant_Code` , `Fiscal_Year` , `Capital` )
VALUES (
(
SELECT Project_Code, Grant_Code, FY, SUM( Capital )
FROM Grants_Temp
WHERE Project_Code = 'OSUT'
AND FY = '2006'
AND Claim_Month = '072006'
GROUP BY Grant_Code
ORDER BY Grant_Code
)
)

[fenway]

You can't mix VALUES with SELECT.  Drop the extra VALUES() clause... it should read INSERT INTO...SELECT ...WHERE....

[alias47]

Thanks fenway, that worked