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