Re: SELECT TOP 3 scores in each class with JOIN
Now we are on the same page!!!
Excellent, however, there still has to be a join or union.
>One could write a complicated Left Join to awards in there, which obviously you're free to do
This is what the entire question is about.
It's too complicated for me so I've been asking for help.
In my sample data only 1 award has the words 'Best of' so we can't rely on that.
plus the awards can grow later with all kinds of titles. In fact, there is a 'Longest Distance Driven' award. lol
Thus, the complicated join or union to Awards.DSQ
award (string), DSQ (boolean)
so the join would be on award and the needed column is DSQ.
(I have an entire program made for this and changing every column name to all lowercase is not time essential. Plus I like the way it looks to me so I'll keep the case structure)