Concatenate two Tables

[#1]

Good Morning,

i have 2 "description" tables in 2 different databases. I have to create only a tables with the value of the 2 previous tables.

How i can do this??


Thank you soo much.....

[#2]

you want all the records from both the tables then use UNION

If you want matching records then use Equi JOIN.

-Raghu

[#3]

Thank you for answer...

I have tried to use UNION comand but it doesn't work.

My databases are in access97.

[#4]

try "concate " e.g

table1:

load ................................ from

concate

table 2:

load ..................................... from

[#5]

I posted this a while back. Basically I concatenate both tables to a temp table. Reload this temp table into a table an delete the temp table. It solves a lot of issues when concatenating data...

Edited ... wrong example, correct one below

SalesDocItem_temp:
LOAD
[Subtotal 6_KZWI6] as OrderAmount,
MaterialNumber_Key,
SalesDocument_Key
FROM (qvd)
Where MaterialNumber_Key ='000000037000002000';

concatenate
LOAD
[Sales doc.type_AUART] as OrderType,
[Document date_AUDAT] as DocumentDate,
SalesDocument_Key
FROM (qvd);

SalesDocItem:
NOCONCATENATE LOAD
SalesDocument_Key,
OrderAmount,
MaterialNumber_Key,
OrderType,
DocumentDate

RESIDENT SalesDocItem_temp;

DROP table SalesDocItem_temp;

[#6]

If two tables that are to be concatenated have different sets of fields, concatenation of two tables can still be forced with the concatenate prefix. This statement forces concatenation with an existing named table or the latest previously created logical table.

tab2:

load * from file2.csv;

.. .. ..

Concatenate (tab1) load * from file3.csv;