Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Retorna o nome do usuário e a regional para a qual o mesmo tem permissão de acesso
- SELECT tb_usuario.nome AS nome_usuario, tb_regional.nome AS regional_permitida
- FROM tb_usuario
- INNER JOIN tb_regional_usuario ON (tb_usuario.id = tb_regional_usuario.tb_usuario_id)
- INNER JOIN tb_regional ON (tb_regional_usuario.tb_regional_id = tb_regional.id)
- WHERE tb_usuario.id = 33
- ORDER BY tb_regional.nome
Advertisement
Add Comment
Please, Sign In to add comment