Concatenate two tables with new connection.

[#1]

Hi there,

I'm trying to concatanate two table, however, it doesn't work.

Actually, i load those two tables from a different server , so i've a new connection between those two in my script.

I guess my concatenate doesn't work because of that, i've tried several things but without any succes:

Connect to...

Load...

SQLSelect*

from...

Concatenate

Connect to ...

Load...

SQL Select*

from...

Is there any way to concatenate those two tables?

Thanks.

[Miguel_Angel_Baeyens]

Hello,

Use CONCATENATE keyword just before the second LOAD statement. I'd recommend you anyway to use a precedent load script just in case.

Regards.

[#3 · Accepted solution]

i was very close,

works perfect thanks