Doubt in joining two select Queries..Plz solve this query

Question

0.00/5 (No votes)

See more:

SQL

I've executed two select statements 

output of 1 is 

Name    Qty     Avg
AAAA     12      10.2
bbbb     10      10.5


output of 2 is 

Name    Qty2    Avg2
CCCC     10      10.5
AAAA     12      12.5



What i Actually want is 

Name   Qty    Avg   Qty2   Avg2
AAAA   12     10.2   12     12.5
bbbb   10     10.5   null   null
CCCC   null   null   10     10.5



Can Someone plz solve this Query??

Posted 5-Dec-13 18:16pm

VIP Venkatesan

Add a Solution

3 solutions

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)

Ganesh Raja · Answer 1 · 2013-12-05T19:03:00

Solution 1

Below Query will provide ur solution..

SQL

 SELECT  A.[Name]
    ,B.[Qty]
    ,B.[Avg]
    ,C.Qty2
    ,C.Avg2
      FROM (select name from [dbo].[1] union select name from [dbo].[2])as A
left join
[dbo].[1] AS B on A.Name =B.Name  left join [dbo].[2] AS C
ON A.Name =C .Name

Posted 5-Dec-13 19:03pm

Ganesh Raja

Updated 5-Dec-13 19:06pm

v3

BrishPandey · Answer 2 · 2013-12-06T01:45:00

Solution 2

http://en.wikipedia.org/wiki/Join_(SQL)[^]

Posted 6-Dec-13 1:45am

BrishPandey

Jain Nishant · Answer 3 · 2013-12-08T21:57:00

Solution 3

Use CTE (Common table Expression) for this:-

With T1
as
( // first select query ),
T2
as
( // second select query )
select T1.Name,T1.Qty,T1.Avg,T2.Qty2,T2.Avg2 from T1

Hope this will help you......

Posted 8-Dec-13 21:57pm

Jain Nishant