怀疑加入两个select Queries..Plz解决了这个问题 [英] Doubt in joining two select Queries..Plz solve this query
本文介绍了怀疑加入两个select Queries..Plz解决了这个问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
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屋!
查看全文