|
Posted by ZeldorBlat on 11/03/05 19:56
You need to take what you have and use it as a subquery as you've
suggested. Other than the subquery, there's no way in SQL to say "give
me the id column from the right table where some other column in the
right table has it's max value".
The reason you can't do that is simple: what id would you get back
from the right table if the maximum value occured in more than one row?
Navigation:
[Reply to this message]
|