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.
| 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 |
 |
|
|
antoniomm91
Starting Member
7 Posts |
Posted - 2011-02-03 : 07:51:52
|
quote:
Originally posted by MIK_2008
Select Col1 From Table1
Union All
Select Col1 from Table2
You're awesome! Thanks!
Tony |
|
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-02-08 : 00:22:30
|
yrw 
Cheers
MIK |
|
|
|
|
|
|
Select and join field from 2 tables into 1 column