Kokoro Posted May 12, 2006 Share Posted May 12, 2006 Ok, I have two tables:TotalSales:EmpID Employee Sales1 Employee1 1002 Employee2 2103 Employee3 90TodaySales:EmpID Sale1 422 35I need to update the first table by summing up the sales from the secod table to the sales from the first table of the corresponding employee. The updated table should look like this:TotalSales:EmpID Employee Sales1 Employee1 1422 Employee2 2453 Employee3 90Any idea? Link to comment Share on other sites More sharing options...
Kokoro Posted May 14, 2006 Author Share Posted May 14, 2006 Well, I've found the answer, but I don't feel like posting it. Nobody here seems to care much about sql anyway. Link to comment Share on other sites More sharing options...
justsomeguy Posted May 15, 2006 Share Posted May 15, 2006 People help where they can. If you are good with SQL and feel like you can answer questions people have, feel free. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now