Thanks to you both. I did look up Top and Order by, but I couldn't figure out how to pick them out for each unique patient ID. I...

Thanks! I'll try profiler.

When I add left, I get results this time, but all of the fields that result are NULL.