Hello Nick. Thanks for the reply. Yeah I just came up with the same myself as a Q of Qs. I tried it in the original union query, which would be the ideal solution for me having it all in the same query, but Oracle throws me an inconsistent data types error?? Can SUM be used in a union on oracle?
Anyhoo it works with the Q of Q and no real difference in the performance. Again thanks for your reply. cheers Martin >> The results are great but in some instances a country will appear twice, >> with two different count values, I want the country to appear once with >> the total count of both results. > >select COUNTRY, sum(NB_PROFILES) from >(your entire select statement here) >group by COUNTRY > >should do it? > >Nick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246504 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
