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?
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
1.4m articles
1.4m replys
5 comments
56.9k users