Now I got the solution...
thanks for not replying
select
a.User_PID as User_PID,
a.Int_Data1 as Door_ID,
a.Local_DT as TimeInOut,
a.Int_Data2 as BadgeCd,
'Web Service' as CreateUserID,
sysdate() as CreateDate
from pub.journ as a
inner join (select c.User_pid as userid, Max(c.Local_DT)as...