I think you can just leave year and county tables 'unlinked' and still OUTER
JOIN to your raw_pur table by both year and county_cd. Dunno, but it's worth a
try:
SELECT y.year,
c.coname,
p.process_mt
FROM (year y,
county c) LEFT OUTER JOIN
raw_pur p ON y.year = p.year
AND c.county_cd = p.county_cd
WHERE y.year = @year
ORDER BY y.year, c.coname
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314851
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
