> I think it's a little bit more complicated that that. If I understand > the question correctly he wants the latest row for each > "Location". That's a lot trickier to do in plain SQL. With Sybase I'd > probably use a temp table to accumulate the appropriate results and > then select all the data from the temp table.
Think of it this way, "order by ID, date" and take the last entry for each ID. I don't really care much about the uniqueness of Location so much as getting only the latest entry for each ID. Does that help? Thanks --Chuck
