Hi, Is it possible to do a query like this in propel (using criteria):
select city, state_iso_value as state, country_iso_value as country, count(provider_id) as goalies from (select distinct f.city as city, p.provider_id, f.state_iso_value, f.country_iso_value from v_facility f, facility_provider p where f.facility_id = p.facility_id) as fp group by city order by goalies desc, country desc, state desc I am thinking no... but I thought I'd see if I might be mistaken. Thanks, Steve --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
