Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT a.chave, pe.cpf, lpad(pe.senha_decriptografada, 6, '0')
- FROM pessoas AS pe
- LEFT JOIN alunos AS a
- ON a.pessoa_id = pe.id
- WHERE a.deletado = 'N'
- AND pe.deletado = 'N'
- AND pe.senha_decriptografada IS NOT NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement