The syntax that you used works in most databases, but not in MS Access. Access only allows one join per query without parenthesis. You can use parenthesis to join two tables together in one set and then join that set to a third table, however. Not as easy, but it does work.
Steve > 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:300675 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
