Select and join field from 2 tables into 1 column

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Select and join field from 2 tables into 1 column

Author

Topic

antoniomm91
Starting Member

7 Posts

Posted - 2011-02-01 : 15:50:39

Hello everyone, I need to join two text fields from different tables into one single column result.
Let me show you what I need.

Let's say I have this table

TABLE1
COL_NAME
Value1
Value2
Value3
.
.
.
Value N

In the other hand I have this table:

TABLE2
COL_NAME
Value A
Value B
Value C
.
.
.
Value N

I need a SQL statement that results like this

COL_NAME
Value 1
Value 2
Value 3
Value A
Value B
Value C
.
.
.
Value N

Can this be done? If so, how?

Thank you in advance!

Tony

MIK_2008
Master Smack Fu Yak Hacker

1054 Posts

Posted - 2011-02-03 : 07:38:47

Select Col1 From Table1
Union All
Select Col1 from Table2