Advertisement
Guest User

Untitled

a guest
Nov 9th, 2017
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.24 KB | None | 0 0
  1. select d.id, dc.sum, dc.calc_date
  2. from debt d
  3.     inner join (
  4.         select dc.parent_id, dc.sum, dc.calc_date
  5.         from debt_calc dc
  6.         where dc.id in (
  7.             select max(id)
  8.             from debt_calc
  9.             group by parent_id
  10.         )
  11.     ) dc on dc.parent_id = d.id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement