mysql> select Preferences.i_preference_desc, Preference_Desc.name, Preference_Desc.value as range_value, Preferences.value as value, Preference_Desc.def_value from Preferences, Preference_Desc WHERE Preferences.i_preference_desc=Preference_Desc.i_preference_desc and i_account=894; +-------------------+------------------+------------------------------------+-----------------------+-----------+ | i_preference_desc | name | range_value | value | def_value | +-------------------+------------------+------------------------------------+-----------------------+-----------+ | 0 | mode | voicemail, auto_attendant | voicemail | voicemail | | 1 | password | | 777 | | | 2 | password_ask | yes, no | no | no | | 3 | prompt_levels | standard, extended, rapid | standard | standard | | 4 | announce_dt | yes, no | no | no | | 5 | auto_play | yes, no | no | no | | 6 | greetings | standard, extended, personal, name | personal | standard | | 7 | fax_file | multi_png, multi_tiff, pdf, tiff | pdf | pdf | | 8 | iso_639_1 | RefB=Languages | en | en | | 9 | ext_email | | robscovell@notonyournelly.com | | | 10 | ext_email_action | none, forward, notify, copy | forward | none | +-------------------+------------------+------------------------------------+-----------------------+-----------+ 11 rows in set (0.00 sec)