combine result of two sql query

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

SQL

SQL-Server

, +

I have two queries

first -

SQL

select order_type, sum(order_value)as "Total"
from tpayment_order
group by order_type

which gives me result as -

SQL

order_type    Total
  C           345439
  P           5435
  T           787

Second -

SQL

select description from order_status_ref

which gives me result as

SQL

description
Collection
Payout
Travel Payout

I want to write a query which will give result as

SQL

Order_type    description    Total 
C              Collection    4565
P              Payout        4423
T            Travel Payout   456546

The

SQL

order_status_ref

table stores the description for each order type

Posted 23-Feb-12 4:21am

vikram_shinde

Add a Solution

3 solutions

Solution 1

Hi,

Try joining

SQL

SELECT A.order_type, sum(A.order_value) AS "Total", B.Description
FROM tpayment_order A, order_status_ref B
WHERE A.order_type=B.order_type
GROUP BY order_type, order_status_ref

But a vital assumption is that the order_status_ref is table with the following mapping:

SQL

order_type | Description

Without this mapping, the joining would be meaningless.

*Mark as answer if this solves your query.

Posted 23-Feb-12 4:32am

Jyothikarthik_N

Comments

vikram_shinde 23-Feb-12 10:39am

yah.. that's the mapping ....

Rajesh Anuhya 23-Feb-12 10:44am

You mean order_status_ref have only one column i.e description??
--RA

[no name] 23-Feb-12 10:41am

Then this query should solve. Do try it!

vikram_shinde 23-Feb-12 10:56am

order_status_ref has two column - order_type and description

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Shameel · Accepted Answer · 2012-02-23T04:34:00

Solution 2

Use INNER JOIN[^]

Posted 23-Feb-12 4:34am

Shameel

vikram_shinde · Accepted Answer · 2012-02-23T05:09:00

Solution 3

It get solved ---- many thanks.... I have used following query

SQL

SELECT T.order_type, R.[description], SUM(order_value) AS [Total]
FROM tpayment_order T
INNER JOIN tpayment_order_type_ref R ON T.order_type = R.order_type
GROUP BY T.order_type, R.[description]

Posted 23-Feb-12 5:09am

vikram_shinde

Updated 23-Feb-12 5:11am

v3