Re: SELECT TOP 3 scores in each class with JOIN

[Peter Brawley]

> I still need to have the rest of the data.

Unclear.

> your query now excludes all the rest of the data.

My query? It's your query with a couple of necessary corrections and the join you asked for. What are you talking about?

> HOW DO I GET ROWS WHERE Awards.DSQ does not apply?

First, please don't shout, it helps nothing, and annoys. And didn't you say you'd got rid of uppercase in database object names?

Now, does "Where awards.dsq does not apply" mean something different from awards.dsq<>1?

> I only wanted to exclude Awards.DSQ = 1

Indeed, exactly what ...and a.dsq <> 1... says and does.