>Still cannot feature what is wrong with the Select emp_id, out_time, late where out_time in (select max(out_time) from t_ndata )......... which give some missing results.
>
>Any advise or helps is really appreciated. Thank alot.

Can you give me more sample data like in your first post that will show me what records are missing?