Advertisement
Guest User

Untitled

a guest
Jul 20th, 2017
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. SELECT DISTINCT
  2. *
  3. FROM Tarefa T
  4. WHERE
  5. T.TarID in(select TarID from Tarefa where T.TarTitulo = 'Bloquear Cliente - Inadimplente' AND T.TarTipID = 572
  6. and T.TarID not in (select TarID from Tarefa where TarTipID = 574 and TarTitulo = 'Desbloqueio Cliente'))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement