Sample Header Ad - 728x90

MySQL Query duplicates sum for left join

0 votes
1 answer
100 views
I have 2 tables, Greeter_Detail and ZipCode_Details I'm trying to SUM the total of People and Families from and Greeter_Detail and join them on ZipCodes, but I get duplicates. ZipCode_Details has city and county info. Can anyone help, I've been on this for hours. Seems like it should be straight forward. TIA! SELECT SUM(Families), SUM(People), Zipcode, ZipCode_Detail.Zipcode_D, ZipCode_Detail.City, ZipCode_Detail.County FROM Greeter_Detail LEFT JOIN ZipCode_Detail ON Greeter_Detail.Zipcode = ZipCode_Detail.Zipcode_D WHERE $dateRange GROUP BY Zipcode
Asked by angel12333 (1 rep)
Jan 4, 2024, 12:45 AM
Last activity: Jan 4, 2024, 01:48 AM