I have the following query in ColdFusion but I am getting an error buy I can't
understand what I am doing wrong. I will appreciate any help I can get:
SELECT c.ConstituencyName, s.ConstituencyNo, c.RegionCode, SUM(v.Votes) AS
TotalVotes
FROM Constituency c
INNER JOIN PollingStation s ON c.ConstituencyNo = s.ConstituencyNo
INNER JOIN VoteResults v ON s.AgentPhoneNo = v.AgentPhoneNo
WHERE v.ResultCategory = 'L' AND v.Party = 'NPP'
GROUP BY c.ConstituencyName, s.ConstituencyNo, c.RegionCode
ORDER BY c.ConstituencyName
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Syntax error (missing operator) in query expression
'c.ConstituencyNo = s.ConstituencyNo INNER JOIN VoteResults v ON s.AgentPhoneNo
= v.AgentPhoneNo'.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300674
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
