如何订购avery UNION SELECT？ [英] How make order for avery UNION SELECT?

问题描述

SELECT "type", idTYPEORDER AS "id", TYPEORDERNAME'.$this->prefix.' AS "name", TYPEORDERNAME as name_d FROM typeorder UNION
SELECT "estate", idTYPE, TYPENAME'.$this->prefix.', TYPENAME FROM type_estate UNION
SELECT "flats", idAPARTAMENT_FLATS, APARTAMENT_FLATSNAME'.$this->prefix.', APARTAMENT_FLATSNAME FROM apartament_flats UNION
SELECT "currency", idCURRENCY, CURRENCYNAME, CURRENCYNAME FROM currency UNION
SELECT "country", idCOUNTRY, COUNTRYNAME'.$this->prefix.', COUNTRYNAME FROM country UNION
SELECT "region", idREGION, REGIONNAME'.$this->prefix.', REGIONNAME FROM region UNION
SELECT "city", idCITY, CITYNAME'.$this->prefix.', CITYNAME FROM city UNION
SELECT "village", idVILLAGE, VILLAGENAME'.$this->prefix.',VILLAGENAME FROM village UNION
SELECT "bedroom", idBEDROOM, BEDROOMNAME'.$this->prefix.', BEDROOMNAME FROM bedroom UNION
SELECT "position", idPOSITION, POSITIONNAME'.$this->prefix.', POSITIONNAME FROM position UNION
SELECT "toilet", idTOILET, TOILETNAME'.$this->prefix.', TOILETNAME FROM toilet UNION
SELECT "view", idVIEW, VIEWNAME'.$this->prefix.', VIEWNAME FROM view UNION
SELECT "flat", idAPARTAMENT_FLAT, APARTAMENT_FLATNAME'.$this->prefix.', APARTAMENT_FLATNAME FROM apartament_flat UNION
SELECT "repair", idREPAIRTYPE, REPAIRTYPENAME'.$this->prefix.', REPAIRTYPENAME FROM repairtype UNION
SELECT "project", idPROJECT, PROJECTNAME'.$this->prefix.', PROJECTNAME FROM project UNION
SELECT "rooms", idApartamentrooms, APARTAMENTROOMS'.$this->prefix.', APARTAMENTROOMS FROM apartament_rooms UNION
SELECT "position_type", idPOSITION, POSITIONNAME'.$this->prefix.', POSITIONNAME FROM position_type UNION
SELECT "comfort", idCOMFORT, COMFORTNAME'.$this->prefix.', COMFORTNAME FROM comfort UNION
SELECT "metro", idMETRO, METRONAME'.$this->prefix.', METRONAME FROM metro

我希望每个SELECT都使用ORDER BY'name_field' DESC

有可能吗？

I want that every SELECT will be with ORDER BY 'name_field' DESC
Is it possible?

推荐答案

this-> prefix。' AS name，TYPEORDERNAME as name_d FROM typeorder UNION
SELECT estate，idTYPE，TYPENAME ' 。

this->prefix.' AS "name", TYPEORDERNAME as name_d FROM typeorder UNION SELECT "estate", idTYPE, TYPENAME'.

this - >前缀。'，TYPENAME FROM type_estate UNION
SELECT flats，idAPARTAMENT_FLATS，APARTAMENT_FLATSNAME ' 。

this->prefix.', TYPENAME FROM type_estate UNION SELECT "flats", idAPARTAMENT_FLATS, APARTAMENT_FLATSNAME'.

this-> prefix。'，APARTAMENT_FLATSNAME FROM apartament_flats UNION
SELECT currency，idCURRENCY，CURRENCYNAME，CURRENCYNAME FROM 货币 UNION
SELECT country，idCOUNTRY，COUNTRYNAME ' 。

this->prefix.', APARTAMENT_FLATSNAME FROM apartament_flats UNION SELECT "currency", idCURRENCY, CURRENCYNAME, CURRENCYNAME FROM currency UNION SELECT "country", idCOUNTRY, COUNTRYNAME'.

这篇关于如何订购avery UNION SELECT？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！