Toad World® Forums

Append or Concatenate 2 Tables

Hi All,

Would really appreciate some help here.

Lets say I have 2 tables

Table 1=

ABCD 1234

ABCD 2345

Table 2=

DEFG 3456

DEFG 4567

I need to create a 3rd table as

Table 3=

ABCD 1234

ABCD 2345

DEFG 3456

DEFG 4567

I have tried UNION and INTERSECT but cannot get the output I expect.

Regards,

bjoshi

Union should return the results you are expecting. What is the actual SQL you have written?

On Wed, Nov 23, 2016 at 9:29 AM, bjoshi bounce-bjoshi@toadworld.com wrote:

Append or Concatenate 2 Tables

Thread created by bjoshi
Hi All,

Would really appreciate some help here.

Lets say I have 2 tables

Table 1=

ABCD 1234

ABCD 2345

Table 2=

DEFG 3456

DEFG 4567

I need to create a 3rd table as

Table 3=

ABCD 1234

ABCD 2345

DEFG 3456

DEFG 4567

I have tried UNION and INTERSECT but cannot get the output I expect.

Regards,

bjoshi

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle Forum notifications altogether.

Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.


Phyllis Helton

Data Magician
Digital Products & Strategies, Cru | Data Sciences & Analytics
Office :phone: 407-515-4452

phyllis.helton@cru.org

just the simple one ,

select * from Table 1

UNION ALL

select * from Table 2

Union should work.

What result did you get? Or did you get any error?

I just ran this query: create table mark3 as select * from mark union all select * from mark2;

It created the table mark3 with the data from mark and mark2. No problem.