I have two separate queries that I need to somehow combine into one recordset. I actually need to sum the total meals and the total working hours. however, the first query yields 37 records while the other only yields 2. How can I combine the two so that I get one recordset with the total meals and total hours each summed separatly?
Select schools.site, schools.area,
schcat, schoolName, d_tot_meals as 'total meals'
From schools, tbl_scanned_sales
Where schools.site = '003'
and month(sc_sales_date) = '9'
and tbl_scanned_sales.sc_site=schools.site
Group By schools.site,
schools.area, schcat, SchoolName, d_tot_meals
Select schools.site, schools.area,
schcat, schoolName, total_hours as 'total hours'
From schools, tbl_empl_trans
Where schools.site = '003'
and month(week_ending_date) = '9'
and tbl_empl_trans.site=schools.site
Group By schools.site,
schools.area, schcat, SchoolName, total_hours
Select schools.site, schools.area,
schcat, schoolName, d_tot_meals as 'total meals'
From schools, tbl_scanned_sales
Where schools.site = '003'
and month(sc_sales_date) = '9'
and tbl_scanned_sales.sc_site=schools.site
Group By schools.site,
schools.area, schcat, SchoolName, d_tot_meals
Select schools.site, schools.area,
schcat, schoolName, total_hours as 'total hours'
From schools, tbl_empl_trans
Where schools.site = '003'
and month(week_ending_date) = '9'
and tbl_empl_trans.site=schools.site
Group By schools.site,
schools.area, schcat, SchoolName, total_hours