Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT pdl, date_start FROM contract_sugar_contract AS doublons
- WHERE pdl IN
- (
- SELECT pdl FROM contract_sugar_contract
- WHERE pdl IN
- (
- SELECT pdl FROM contract_sugar_contract
- GROUP BY pdl
- HAVING COUNT(pdl)>1
- )
- AND crm_status <> '99' AND date_start IS NULL
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement