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>