I'm trying to pull information from a table as follows: Table: PHONE PhoneClass Number Fax 123-123-1234 Main 123-123-1234 Fax 123-123-1234 Main 123-123-1234 etc..... Main is mapped as phone Fax is mapped as fax I'm outputting this information on a form that has mapped fields. The problem here is that I cant change the table names to correspond to the mapped fields already created. Therefore, I wont to be able to pull this information seperatly. Wanted to know if there is any sql that will allow me to pull this separetly...... Thanks, Edward V. Hayes II Medical/Manager WebMD --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php