MySQL Forums
Forum List  »  Portuguese

Como fazer?
Posted by: Vitor Freitas
Date: July 08, 2014 09:12AM

Olá. Sem querer abusar gostaria de colocar uma questão, pois tenho tentado sem sucesso obter um determinado resultado.

Se tiver a seguinte tabela:
|Grupo |User |EventDate |Event |Campanha
Evolution 1012 2014-07-07 10:36:04 LOGIN AUTENTI1
Evolution 1012 2014-07-07 10:38:18 LOGOUT AUTENTI1
Evolution 1012 2014-07-07 10:38:28 LOGIN AUTENTI1
Evolution 1012 2014-07-07 10:39:21 LOGOUT AUTENTI1
Evolution 1012 2014-07-07 10:41:46 LOGIN EVOL1
Evolution 1012 2014-07-07 13:09:53 LOGOUT EVOL1
Evolution 1012 2014-07-07 13:11:19 LOGIN EVOL1
Evolution 1012 2014-07-07 13:39:49 LOGOUT EVOL1

Como obtenho o Login e logout na mesma linha?
|Grupo |User |Login |LogOut |Campanha
Evolution 1012 2014-07-07 10:36:04 2014-07-07 10:38:18 AUTENTI1
Evolution 1012 2014-07-07 10:38:28 2014-07-07 10:39:21 AUTENTI1
Evolution 1012 2014-07-07 10:41:46 2014-07-07 13:09:53 EVOL1
Evolution 1012 2014-07-07 13:11:19 2014-07-07 13:39:49 EVOL1

Desde já obrigado.

Options: ReplyQuote


Subject
Views
Written By
Posted
Como fazer?
2806
July 08, 2014 09:12AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.