Postgres Pro
Downloads
Home   >   mailing lists

joins with aggregates - Mailing list pgsql-sql

From Remigiusz Soko³owski
Subject joins with aggregates
Date
Msg-id 36712F3D.8DC8D68F@gdansk.sprint.pl
Whole thread Raw
List pgsql-sql
Tree view 
Hi!
I'm wonder if it is possible to make a query which joins data from two
tables and also aggregates some columns of one of them
I mean something like
SELECT p1.id_prod, p1.name_prod, d1.id_prod, sum(d1.quant_detal) FROM
prod p1, detal d1 WHERE p1.id_prod=d1.id_prod
GROUP BY p1.id_prod;
    TIA
    Rem

pgsql-sql by date:

Previous
From: Michael Yeung
Date:
Subject: Lock the server
Next
From: George Moga
Date:
Subject: Re: [SQL] joins with aggregates