怀疑加入两个select Queries..Plz解决了这个问题 [英] Doubt in joining two select Queries..Plz solve this query

问题描述

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??

推荐答案

以下查询将提供你的解决方案..

< br $>

Below Query will provide ur solution..

 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

http ：//en.wikipedia.org/wiki/Join_（SQL） [ ^ ]

使用CTE（公用表表达式）为此： -



随着T1

为

（//第一次选择查询），
T2

as

（//第二选择查询）

选择T1.Name，T1.Qty，T1.Avg ，T2.Qty2，T2.Avg2来自T1





希望这会对你有所帮助......

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......

这篇关于怀疑加入两个select Queries..Plz解决了这个问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！