Postgres Pro
Downloads
Home   >   mailing lists

Query to find sum of grouped counts from 2 tables - Mailing list pgsql-general

From Satish Burnwal (sburnwal)
Subject Query to find sum of grouped counts from 2 tables
Date
Msg-id 3A8C969225424C4D8E6BEE65ED8552DA036B2F55@XMB-BGL-41C.cisco.com
Whole thread Raw
Responses Re: Query to find sum of grouped counts from 2 tables
Re: Query to find sum of grouped counts from 2 tables
List pgsql-general
Tree view 
I have 2 tables containing the data for same items:

STORE1
-----------------------------
Id    type        items
-----------------------------
1    FOOD        10
2    FOOD        15
3    SOAP        20

STORE2
-----------------------------
Id    type        items
-----------------------------
1    FOOD        15
3    SOAP        10
4    PAPER        25
5    SOAP        12


What I am looking for is one single query that would return me TYPE-wise
total number of items from both the tables. UNION does not help me. I
want the result as:

Type        count
-----------------------
FOOD        40        //10+15+15
SOAP        42        //20+10+12
PAPER        25

Thanks in advance,
-Satish

pgsql-general by date:

Previous
From: "Benjie Buluran"
Date:
Subject: Re: Inserting data from one database to another using stored functions
Next
From: Thomas Kellerer
Date:
Subject: Re: Query to find sum of grouped counts from 2 tables