Query to find sum of grouped counts from 2 tables

Поиск
Список
Период
Сортировка
От Satish Burnwal (sburnwal)
Тема Query to find sum of grouped counts from 2 tables
Дата
Msg-id 3A8C969225424C4D8E6BEE65ED8552DA036B2F55@XMB-BGL-41C.cisco.com
обсуждение исходный текст
Ответы Re: Query to find sum of grouped counts from 2 tables
Re: Query to find sum of grouped counts from 2 tables
Список pgsql-general
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 по дате отправления:

Предыдущее
От: "Benjie Buluran"
Дата:
Сообщение: Re: Inserting data from one database to another using stored functions
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: Query to find sum of grouped counts from 2 tables