Please some help on a join question with sum aggregate - Mailing list pgsql-general

Hi,

I havbe the following SQL related question.

Table AA:

id, seqno, price

A10    1    1000.0

A10    2    2000.0



Table BB:


id    seqno        subseq    price

A10       1        1        10

A10       1        2        20

A10       1        3        30

A10        2        1        25


I would like to have a query that joins table AA and BB to the result:

id    seqno    price
A10    1        1060
A10    2        2025

Thanks,

Feite Brekeveld