How to do a count on a union query

Viewed 74113

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?

6 Answers
Related