Terry Carroll wrote:
> On Wed, 22 Aug 2007, z machinez wrote:
>
>> Hi All:
>>
>> I have the following tables selected from a database:
>>
>> a1
>>
>> a2
>>
>> each table are of the same column length, same col names. How do I combine
>> or concatenate these tables ? So, I would like to have
>>
>>
On Wed, 22 Aug 2007, Kent Johnson wrote:
> Terry's ideas are good but it might be as simple as
> a3 = a1 + a2
> if you don't need to worry about duplicates.
Doh! I was thinking the no duplicates was part of it, but you're right;
that's nowhere in the OP's question.
_
z machinez wrote:
> Hi All:
>
> I have the following tables selected from a database:
>
> a1
>
> a2
>
> each table are of the same column length, same col names. How do I
> combine or concatenate these tables ? So, I would like to have
>
> a3 = a1, a2 # combining all the rows into one fo
On Wed, 22 Aug 2007, Terry Carroll wrote:
> If you want to pull them out of the database as a single table
> I was wondering that myself the other day. I was planning on looking
> into whether you could just do a FULL OUTER JOIN (which is essentially a
> union operation) on both tables. I
On Wed, 22 Aug 2007, z machinez wrote:
> Hi All:
>
> I have the following tables selected from a database:
>
> a1
>
> a2
>
> each table are of the same column length, same col names. How do I combine
> or concatenate these tables ? So, I would like to have
>
> a3 = a1, a2 # combining all the
Hi All:
I have the following tables selected from a database:
a1
a2
each table are of the same column length, same col names. How do I combine
or concatenate these tables ? So, I would like to have
a3 = a1, a2 # combining all the rows into one formal table
Just not sure how to do that in Pyth
