I have a tough nut to crack of a SQL report. First off, this is against a Oracle 11ge database if that matters.
I have two tables. Table A use_no (key) county rec_type 1 1 X 3 1 X 4 1 Y 5 2 X 6 2 X 7 2 Y 10 2 Y TableB use_no (key) dup_set 1 A 2 A 7 B 8 B 9 B I am trying to join these together so I can make a report that looks like this. county rec_type records record_with_dups 1 X 2 3 1 Y 1 1 2 X 2 2 2 Y 2 4 But I have no idea how to join these table together to accomplish this. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:319832 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
