|
|
|
Author |
Message |
wixon21
|
Posted: Mon Oct 22 16:34:38 PDT 2007 |
Top |
SQL Server Developer >> Select question
Hi,
I think this should be easy, but I can't find the answer...
I need to combine a column from two seperate tables.
So, if Bill, Susan, Fred are 3 rows in TableA, and Cindy, Linda and Mike are
3 rows in TableB, I need a result of 6 rows (only one column) with Bill,
Susan, Fred, Cindy, Linda and Mike.
TIA!!
-Joe
SQL Server144
|
|
|
|
|
Jeffrey
|
Posted: Mon Oct 22 16:34:38 PDT 2007 |
Top |
SQL Server Developer >> Select question
> Hi,
>
> I think this should be easy, but I can't find the answer...
>
> I need to combine a column from two seperate tables.
>
> So, if Bill, Susan, Fred are 3 rows in TableA, and Cindy, Linda and Mike are
> 3 rows in TableB, I need a result of 6 rows (only one column) with Bill,
> Susan, Fred, Cindy, Linda and Mike.
>
> TIA!!
>
> -Joe
>
>
>
Lookup UNION [ALL] in Books Online (BOL).
|
|
|
|
|
Joe
|
Posted: Mon Oct 22 17:13:03 PDT 2007 |
Top |
SQL Server Developer >> Select question
That looks like what I've been searching for.
Thanks Jeffrey!
-Joe
>> Hi,
>>
>> I think this should be easy, but I can't find the answer...
>>
>> I need to combine a column from two seperate tables.
>>
>> So, if Bill, Susan, Fred are 3 rows in TableA, and Cindy, Linda and Mike
>> are 3 rows in TableB, I need a result of 6 rows (only one column) with
>> Bill, Susan, Fred, Cindy, Linda and Mike.
>>
>> TIA!!
>>
>> -Joe
>>
>>
> Lookup UNION [ALL] in Books Online (BOL).
|
|
|
|
|
|
|