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
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.