This works fine joining two queueries together the first one where country_count is more than 5 and the second where country_count is less than 5. How do I add an "alias" so I can give a name to the results of all the second results?
<cfquery name="q_countries" datasource="mydsource"> SELECT UCASE(country) AS Country, COUNT(*) AS country_count, Visit, IFNULL(country='Not Defined', country) FROM clientinfo WHERE month(visit) = #url.monthnowis# GROUP BY country HAVING country_count > 5 UNION SELECT country, COUNT(*) AS country_count, Visit, IFNULL(country='Not Defined', country) FROM clientinfo WHERE month(visit) = #url.monthnowis# GROUP BY country HAVING country_count < 5 ORDER BY country_count </cfquery>
riogrande
02-14-2008 @ 2:24 PM
