select *
  from (
  select
      a.id          as "id from origin"
     ,a.description as "description from origin"
     ,b.id          as "id from destin"
     ,b.description as "description from destin"
  from
    (select id, description, zip_code, city, country, something_more
       from ORIGIN_TABLE) a
   ,(select id, description_text as description, zip_code_cd as zip_code, city_name as city, country_name as country,
     something_more
       from DESTIN_TABLE) b
  where
    a.zip_code = b.zip_code
  order by 2 )