Postgres Pro
Downloads
Home   >   mailing lists

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

From Feite Brekeveld
Subject Please some help on a join question with sum aggregate
Date
Msg-id 3EA195A7.7070800@osiris-it.nl
Whole thread Raw
Responses Re: Please some help on a join question with sum  (Oliver Elphick <olly@lfix.co.uk>)
Re: Please some help on a join question with sum aggregate  (elein <elein@sbcglobal.net>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: stddev returns 0 when there is one row
Next
From: Oliver Elphick
Date:
Subject: Re: Please some help on a join question with sum