What do you see if you order the results by Vehicle.modelId? Do you get multiple rows per model? That's what I'm looking for.
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]