Jason Fisher wrote: > 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: >
This was the right idea. Thanks to Brad providing me the proper term, 'Cartesian,' for what I was trying to do, I was able to find this resource. http://www.dba-oracle.com/t_garmany_9_sql_cross_join.htm This allowed me the build the following SQL FROM years CROSS JOIN county LEFT OUTER JOIN raw_pur ON (raw_pur.county_cd = county.county_cd AND raw_pur.year = years.year AND raw_pur.record_id != '2') The CROSS JOIN is the same as your 'unlinked' year y, county c but explicitly says that you meant to do this and just didn't forget to put a join in your where clause. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:314852 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
