SQL query of Count with multiple tables

Question

I have this query to count the times documentador is repeated in each table

(select count(documentador) AS count, documentador from impo_expo GROUP BY documentador order by documentador) UNION ALL
(select count(documentador), documentador from prov_compr GROUP BY documentador order by documentador) UNION ALL
(select count(documentador), documentador from pedimento GROUP BY documentador order by documentador) UNION ALL
(select count(documentador), documentador from partidas GROUP BY documentador order by documentador) order by documentador asc

OUTPUT:

count   documentador
2          Imelda
4          Imelda
2          Imelda
1          Imelda
2          Juan Enrique
1          Juan Enrique
1          Juan Enrique
1          Juan Enrique
2          Raul

How can i combine them to have something like this?

count   documentador
9         Imelda
5       Juan Enrique
2          Raul

The Fabio · Accepted Answer · 2015-05-18 07:04:25Z

1

How about a "group by" and a "sum" around your query? Something like this:

select documentador, sum(count) as thesum from (
(select count(documentador) AS count, documentador from impo_expo GROUP BY documentador) UNION ALL
(select count(documentador), documentador from prov_compr GROUP BY documentador) UNION ALL
(select count(documentador), documentador from pedimento GROUP BY documentador) UNION ALL
(select count(documentador), documentador from partidas GROUP BY documentador) order by documentador asc
) a group by documentador order by thesum desc

answered May 18, 2015 at 7:04

The Fabio

6,3833 gold badges33 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL query of Count with multiple tables

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related