How do I execute a statement like this:
SELECT COUNT(*) FROM [User].Users + SELECT COUNT(*) FROM [Survey].Users
The idea being that it adds the number of users in schema user and the number of users in schema survey and returns the sum
Another example of what might be executed without involving schemas:
SELECT COUNT(*) FROM ClassApplications + SELECT COUNT(*) FROM CourseApplications
Note that these statements do not execute (syntax error). My question is: How would I word the above statements to get the behavior I'm looking for?