alias47
-
Posts
2 -
Joined
-
Last visited
Never
alias47's Achievements
Newbie (1/5)
0
Reputation
-
#1136 - Column count doesn't match value count at row 1
alias47 replied to alias47's topic in MySQL Help
Thanks fenway, that worked -
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 ) )