I am trying to get the switch information for BOTH the btn_switch_sid and the dnis_switch_sid.  What I get is only for one of the switches.  Even if I get all the info, I'm not sure how to set up the aliases for the overlaping fields.

mysql> SELECT route.*, switch.* FROM route INNER JOIN switch ON route.btn_switch_sid=switch.sid OR route.dnis_switch_sid WHERE route.sid='159' LIMIT 1\G
*************************** 1. row ***************************
             sid: 159
          status: active
  btn_switch_sid: 3
            name:
            note: DTO added on Mar.12.11.
       ani_match:
       ani_trans:
      dnis_match: 12129182000
      dnis_trans:
             btn: 12129182000
             ecf:
             cfu:
            dial:
    dial_timeout: 0
            cfna:
            cfbl:
       voicemail:
             dto: 18006956225
   remote_access: 1
      remote_pin:
     restriction: none
auth_code_prompt: 0
   auth_code_len: 0
auth_code_verify: 0
modify_timestamp: 2012-02-27 19:09:16
   modify_userid: ewieling@nyigc.com
     account_sid: 607
            type: diod
 dnis_switch_sid: 1
   ecf_timestamp: 0000-00-00 00:00:00
     caller_tnis: cnam
             sid: 1
            name: NEXTONE
            note:
          prefix:
            peer: nextone
1 row in set (0.00 sec)

mysql>