Advertisement
Guest User

Untitled

a guest
Jul 20th, 2017
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. select ctm.invoice, ctm.transtype, ctm.correct, ctm.approved, ctm.*
  2. from custTrans ctm
  3. where ctm.invoice IN
  4. (
  5. select ctm.invoice
  6. from custTrans ctm
  7. where ctm.invoice != ''
  8. group by ctm.invoice
  9. having count(*) > 1
  10. )
  11. order by ctm.Invoice
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement