Two columns entire results into single columns

Raj0125 511

Hi ,

select
Class2_Code_Source,
SubClass2_Code_Source,
Product_SubClass2_Name_Source,
c.Product_SubClass1_SKey,
s.Product_SubClass1_SKey
from SubClass2_Source s
Inner join SubClass1 c on s.Product_SubClass1_SKey=c.Product_SubClass1_SKey

I want 2 Product_SubClass1_SKey from 2 different tables in to single column.How can i achive this

Accepted answer

Alberto Morillo 34,461 Reputation points MVP

2022-06-30T12:13:13.933+00:00

SELECT t.Product_SubClass1_SKey
FROM
(
SELECT c.Product_SubClass1_SKey
FROM SubClass1 c
UNION
SELECT s.Product_SubClass1_SKey
from SubClass2_Source s
) t
Please sign in to rate this answer.
Raj0125 511 Reputation points

2022-06-30T13:04:54.62+00:00

In case of left outer join how we can do it.Pls suggest

Alberto Morillo 34,461 Reputation points MVP

2022-06-30T13:31:42.483+00:00

On a LEFT JOIN you will find some null values on the right side table, you can see all those NULL values and also duplicate values between the tow tables using UNION ALL.

SELECT t.Product_SubClass1_SKey
FROM
(
SELECT c.Product_SubClass1_SKey
FROM SubClass1 c
UNION ALL
SELECT s.Product_SubClass1_SKey
from SubClass2_Source s
) t
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Two columns entire results into single columns

0 additional answers

Your answer