Ok Master, Abusando Nuevamente, me falta una utilma cosa, y es ver todo esto según el sales_manager que es un campo de Provider, sería P.sales_manager
Por ejemplo para ver los de 'Pedro Perez', no sé onde se pondría el filtro ???
Inmensas Gracias.
Código PHP:
SELECT P.provider_id, P.company_name, P.country, P.medical_speciality,
C.status_2, C.provider_call_log_id
from provider P inner join provider_call_log C on P.Provider_id=C.Provider_Id WHERE P.active='prospect' AND
C.provider_call_log_id = (SELECT Max(provider_call_log_id)
from provider_call_log where provider_id=P.Provider_Id)
UNION
SELECT P.provider_id, P.company_name, P.country, P.medical_speciality,
NULL AS status_2, NULL as provider_call_log_id
from provider P WHERE P.active='prospect' AND
Provider_id not in (SELECT Distinct(Provider_id) from Provider_call_Log)