I have a table tha hold points of the user. a user may have many points.
How would I select a sum of all the users. I tried
select sum(user_points) where table1.user_id in table2.user_id;
and I have tried other thing as well but I just can't get it right.