Can somebody tell me if it is possible to translate a SQL UNION with Criteria. This is my sql request:
SELECT place_city.id, place_city.city_long_name_FR AS name, place_country.country_short_name_FR, place_city.code FROM place_city LEFT JOIN place_country ON place_city.country_id = place_country.id WHERE place_city.city_long_name_FR like 'parai%' UNION select place_town.id, place_town.town_long_name_FR AS name, place_country.country_short_name_FR, place_town.town_code from place_town LEFT JOIN place_country ON place_town.country_id = place_country.id WHERE place_town.town_long_name_FR like 'para%' ORDER BY name ASC thank you --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
