Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select * from po_schedules_2020 sch
- join po_schedule_2020_position sch_p on sch.id = sch_p.schedule_id --and kvr_undefined is null
- left join contragents co on sch.customer_org_id = co.id
- left join po_schedule_2020_position_finances sch_f on sch_p.id = sch_f.po_schedule_position_id
- join po_vocab_time_periods pvtp on pvtp.id = sch_f.year
- where /*sch_p.date_start is not null and*/ sch.schedule_number = '202003722001732001'
- order by sch_p.number_reg
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement