We help IT Professionals succeed at work.
Get Started

Group and sum query

230 Views
Last Modified: 2012-05-12
Hi,

I have a couple of tables looking like this:
orders
orderID int
paymentTypeID int
sentDate datetime
orderstatusID int

orderDetail
orderID int
price money
quantity int

bklPaymentType
paymentTypeID int
paymentType nvarchar

I want the result to be like this:
paymenttype    totalsum  
Invoice             50000
Mastercard     25000
Visa               50000

This should be for all transactions in a certain month and year that is based on sentDate that holds when the order was sent. Also, only the orders with orderStatusID = 3 should be shown.

How can I achieve this?

Thanks for help!

Peter
Comment
Watch Question
Senior Developer Analyst
Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE