Attendance Database

Sep 22 2016 2:02 AM
i  have data like this 
 
 
 
i need query to get me like this output
 
Attend_Device Attend_User_ID Attend_DATE TIME_IN TIME_OUT
RD1 832 29/09/2015 07:40:45 14:30:45
RD1 833 29/09/2015 07:40:45 14:30:45
RD2 834 29/09/2015 07:40:45 Null
RD2 835 29/09/2015 Null 14:30:45

 Thank 
Ahmed  

Answers (1)