Yes. The important thing to note is that they alias the table in the main part of the select.

PF

>I guess category (i.e. grouping field) is jobid, right?
>
>
>>The standard way in SQL to find the data that corresponds to MIN/MAX is to use a correlated sub-query.
>>
>>The example I have is:
>>
>>

>>select
>>  jobid,
>>  status,
>>  supervisorid
>> from jobprogress m
>> where statusdate =
>>  (select max(statusdate)
>>   from jobprogress
>>   where jobid = m.jobid)
>>

>>
>>
>>The is the typical way to select 1 row for a given ID if there are multiple rows for each ID with a date for each row.
>>
>>PF