When using an access database, I would instead of using inner join
syntax (which I normally prefer) put those join conditions in the where
clause...
FROM Constintuency c, PollinstStation s, VoteResults v
WHERE s.ConstituencyNo = c.ConstituencyNo
and v.AgentPhoneNo = v.AgentPhoneNo
and v.ResultCategory = 'L' AND v.Party = 'NPP'
If I were using my SQL Abstraction layer, this issue would be moot
because it handles the funky nested joins in Access (although I prefer
not to use Access) -- but in lieu of that as a tool option, imo this
syntax here is a bit cleaner and easier to read ... though it's been a
while since I'd done much joining in access, so I don't remember if the
"funky" starts at the 2nd join or the 3rd
hth,
ike
--
s. isaac dealey ^ new epoch
isn't it time for a change?
ph: 503.236.3691
http://onTap.riaforge.org/blog
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:300710
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
