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 по дате отправления: