I've been searching everywhere for this but no cigar. Smoke is starting to come out of my ears. please help

How do you sum two columns in two tables and group by userid?

Have two tables.

Recipe Table
recipeid   userid   recipe_num_views

Meals Table
mealsid   userid    meal_num_views

Goal is to sum the num views in both tables and group by userid

so for example
Recipe Table
1    3     4
2    4     6

Meal Table
1    3     2
2    4     5


select sum(recipe views)+sum(meal views) 
WHERE recipe.userid=meals.userid GROUP BY userid

should give 

userid=3 , sum=6
userid=4, sum=11

this gives a much bigger number.

mysql
Edit
Report