coachmkavanaugh (7/5/2015)
Holy cow, thank you so much! This is very close!!!There seems to be some duplicates returned from the query, sometime 2 times, other times 3, some 4 times.
Times with B return one row, BB seems to return an extra row, A returns 3 rows, AA returns 4 rows, id imagine AAA may return 5?
Okay... this is most likely an issue of what can be selected that is unique to the individual. I have some basic understanding of the concept of a meet, an event within that meet, and an individual competing in that event, but you have the data. You'll need to determine what fields are unique to that event, meet, and individual, and then limit the ORDERED ROWS query to only those fields. Finally, you'll need to be sure that the join in the final query is on all of those fields, so that only 1 record from the source matches the ordered rows record. Does that make sense?
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)