Can I do this in one query... or am I going to have to do some looping and counting?
I have two tables joined in a many to many relation. I would like to count how many records in table A are joined to table B and how many joins between table A and table B. In other words, how many records in table A have one or more errors and how many errors are there, grouped by error code. Table A use_no year Table B error_code TableABjoin use_no year error_code ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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/sql/message.cfm/messageid:3186 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
