Utiliza los nombres de las tablas en los campos
Código:
SELECT provider_contact.title, provider_contact.first_name, etc... provider_contact_phone.phone
FROM provider_contact, provider_contact_phone
WHERE provider_contact.provider_contact_id = provider_contact_phone.provider_contact_phone_id
AND provider_contact_phone.provider_contact_id=86