SUM and COUNT two different tables with one query

[mlvander]

I would like to be able to sum data in one table and count data in another table with one query. Is this possible ? Below is an example of what I would like to accomplish.

tbl_class
classid | provinceID_fk | class_enroll | grade
1 ----------- 1 ---------------- 2 ----------------- 7
2 ----------- 1 ---------------- 3 ----------------- 8
3 ----------- 2 ---------------- 5 ----------------- 7
4 ----------- 2 --------------- 10 ---------------- 8
5 ----------- 2 ---------------- 5 ----------------- 7

tbl_survey
surveyID | classid_fk
1 --------------1
2 -------------- 2
3 -------------- 2
4 -------------- 2
5 -------------- 3
6 -------------- 3
7 -------------- 4
8 -------------- 4
9 -------------- 4
10 ------------- 4
11 ------------- 4
12 ------------- 4
13 ------------- 4
14 ------------- 5
15 ------------- 5

desired result
province | class_enroll | grade | survey_complete
1 -------------- 5 ------------- 7 ------------- 1
1 -------------- 5 ------------- 8 ------------- 3
2 ------------- 10 ------------- 7 ------------- 4
2 ------------- 10 ------------- 8 ------------- 7

The following will get the numbers independenly but I would like to accomplish this in one query.

SELECT SUM(class_enroll) as class_enroll
,provinceID_fk
,grade
FROM tbl_classs
GROUP BY provinceID_fk, grade

AND

SELECT COUNT(surveyID) as survey_complete
,provinceID_fk
,grade
FROM tbl_survey
GROUP BY provinceID_fk, grade

Any help would be appreciated. Thanks for your time.

[code green]

You haven't explained why you want this.
But you could try UNION.
This goes where you have your AND in the post.
UNION must return equal number of fields for each query

[mlvander]

What I want to do is have a complete report for my manager with one query. If I use the UNION as you suggest then my sum of enrollment will be in the same column as my count of completes. This would get quite confusing when I add in 10 provinces and 9 grades per province. I would also like to add a calculation statement that provides the response rate by dividing the two columns. Right now I am using two queries and then importing them into SAS and running a program to create the table that I want to provide to my manager. I was just hoping to do it in one step instead of two.

[code green]

Sorry about that.
A JOIN will return a common group of results

SELECT SUM(class_enroll) as class_enroll,
COUNT(surveyID) as survey_complete,
provinceID_fk,grade
FROM tbl_classs 
JOIN tbl_survey ON classid = classid_fk
GROUP BY provinceID_fk, grade

Not sure if this is what you mean