KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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.
Tags (comma-separated)
Save Edits
Cancel