SQLize | PHPize | SQLtest

SELECT ma.MemID, MAX(ma.attributionDate) AS attDate, ma.AttributionCatID, ma.CINName, ma.LOBPopulation, ma.MemServiceAreaID, COALESCE(p2.ProvID, p.ProvID) ProvID, COALESCE(p2.ProvVendorID, p.ProvVendorID) ProvVendorID, COALESCE(p2.ProvNPI, p.ProvNPI) ProvNPI, COALESCE( p2.provFullName, p.provFullName ) provFullName, COALESCE(p2.ProvPhone, p.ProvPhone) ProvPhone, COALESCE(p2.provSpecID, p.provSpecID) provSpecID, COALESCE( LEFT(p2.provStreetAddress, 255), LEFT(P.provStreetAddress, 255) ) provStreetAddress, COALESCE(p2.ProvCity, p.ProvCity) ProvCity, COALESCE(p2.ProvState, p.ProvState) ProvState, COALESCE(p2.ProvZipCode, P.ProvZipCode) ProvZipCode FROM [ HealthPlanOptima ].[ ODW_Member_Attribution_Month ] ma LEFT JOIN [ HealthPlanOptima ].[ ODW_Provider_Daily ] p ON ma.ProvID = p.ProvID LEFT JOIN [ HealthPlanOptima ].[ ODW_Provider_Daily ] p2 ON ma.ProvID = p2.ProvID GROUP BY ma.memID