Advertisement
Guest User

Untitled

a guest
Mar 23rd, 2019
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. SELECT
  2. c.VATIN,
  3. SUM(
  4. SELECT value_NET * tax_rate/100
  5. FROM Invoice
  6. WHERE c.VATIN = seller_VATIN AND date < s.end_date AND date > s.start_date)
  7. - SUM(
  8. SELECT value_NET * tax_rate/100
  9. FROM Invoice
  10. WHERE c.VATIN = buyer_VATIN AND date < s.end_date AND date > s.start_date),
  11. s.start_date
  12. FROM Client c, Settling_period s
  13. GROUP BY c.VATIN, s.start_date
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement