PostgreSQL, have a column as a sum function

Question

I need the column PrijsExBTW from Factuur to be the total value from all the Prijs from factuuritem where the factuurfactuurnummer from factuuritem is the same as the factuurnummer from factuur

Does anyone have an idea how to do this?

See database model for the references:

mankowitz · Accepted Answer · 2018-06-25 09:25:20Z

2

This should be it.

update Factuur f
set PrijsExBTW = (select sum(Prijs) from factuuitem where factuurfactuurnummer = f.factuurnummer)

answered Jun 25, 2018 at 9:25

mankowitz

2,1151 gold badge19 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL, have a column as a sum function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest