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??
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
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)