Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- выбираем долги без адресов (факт/рег)
- select d.id d_id
- from
- portfolio as p
- inner join debt as d on p.id = d.r_portfolio_id
- --inner join address a on a.parent_id = d.parent_id
- where
- not exists ( --не содержит
- select a.parent_id
- from address a --адресов
- where
- a.typ in (1,2) --с типом (рег/факт)
- and a.parent_id = d.parent_id
- )
- and p.name like '%беззалоговые5107%'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement