Advertisement
Guest User

Untitled

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