troubleshooting Question

function sum on sql

Avatar of rafaelrgl
rafaelrgl asked on
Microsoft SQL Server 2005
4 Comments1 Solution208 ViewsLast Modified:
hi, i want to do this with those tables:

table1:

id      username      name

2       bob23            bob tayl
3       testdf             lkkldfs ds
4       mary3            maryana


table2:

id      idusername     points

1      2                       30
2      2                       20
3      4                       60
4      3                       15
5      4                       10


so i want a table like this:


id    idusuario    username        name          points

1     4                mary3            maryana       60
2     2                bob23            bob tayl        50
3     3                testdf             lkkldfs ds      15

what will be the right syntax for this sql 2005 procedure????
 
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros