mysql - How to do a count on a union query

Question

I have the following query:

select distinct profile_id from userprofile_...

union

select distinct profile_id from productions_...

How would I get the count of the total number of results?

question from:https://stackoverflow.com/questions/11731655/how-to-do-a-count-on-a-union-query

Answer 1

If you want a total count for all records, then you would do this:

SELECT COUNT(*)
FROM
(
    select distinct profile_id 
    from userprofile_...

    union all

    select distinct profile_id 
    from productions_...
) x