At 09:18 19.06.2003 +0000, you wrote:

>I have a similar situation, and use one query like this:
>
>SELECT FIRST 1 Employee, Job, Salary, EffDate
>FROM JobHist
>WHERE Employee=XXXXXX
>ORDER BY EffDate DESC;
>
>I would appreciate other opinions.

This is fine, but will only work when you want information about one
particular employee. The actual question was related to several employees,
and then you have to use one of the other suggestions.

Set