SELECT "type", idTYPEORDER, TYPEORDERNAME FROM typeorder AS TYPEORDER UNION
SELECT "estate", idTYPE, TYPENAME FROM type_estate AS TYPEESTATE UNION
SELECT "apartment", idAPARTAMENT_FLATS, APARTAMENT_FLATSNAME FROM apartament_flats AS APARTAMENT_FLATS UNION
etc.
Marc