Select question  
Author Message
wixon21





PostPosted: 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





PostPosted: 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





PostPosted: 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).