Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select ctm.invoice, ctm.transtype, ctm.correct, ctm.approved, ctm.*
- from custTrans ctm
- where ctm.invoice IN
- (
- select ctm.invoice
- from custTrans ctm
- where ctm.invoice != ''
- group by ctm.invoice
- having count(*) > 1
- )
- order by ctm.Invoice
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement