I need some help getting a SQL query to do exactly what I want.
I have a list of locations, one records for each location. There is a field that contains the size of each location, listed one time.
When I Left Join a table that has information about events at the location, it duplicates the list of locations for every event record. This works fine for the text data, but when I try to then group the data by a shared category, it Sums the size - I want it to sum the size ONCE per location, not for every event. Any ideas?