alias47
-
Posts
2 -
Joined
-
Last visited
Never
Posts posted by 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
)
)
#1136 - Column count doesn't match value count at row 1
in MySQL Help
Posted