Consulta me repite los registros

[jpogsistem]

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