I have the following scenario:
Users table
Table users access
In the usuariosacessos
table, each row has the id
of the user, the name of the feature, and a field stating whether or not you have access.
In my specific case, I need only bring two features.
I tried the following:
select u.codus, u.nome, ua.acessarForm from usuarios as u
inner join usuariosacessos as ua on u.codus = ua.codUsu
where u.login ='SS' and u.senha = '10' and ua.funcionalidade in ('frmTablet_Add', 'frmTablet_Remove');
but it returns me two lines (one for each feature)
I would like to bring this data in just one line.
Is there any way to do this?