Hi,

select max doesn't solve the problem.. let me try to explain
it further.

the idea is the employee will be clocking In and out during the
day and I am trying to find when he last clocked In and if he clocked out.
In my previous example.. the emp is still clocked so if I use max I'll get 18-JUL-02 01:49:00 for timeIn and
18-JUL-02 12:49:00 for timeOut wich is not true. because he
is not clocked out yet.

I hope this helps