Hola, que tal,
Esta consulta me repite los registros, es decir son 43 y me salen 301.....Por que ?
SELECT provider_id, medical_network_id, medical_network, provider_name,
main_specialties, other_specialties, main_phone,
main_fax, phone_code FROM provider, countries WHERE name IN (SELECT country FROM provider)
Gracias de Antemano, uso Mysql 4.19