copy two table

[ja]

hi,

How copy two table between two database?

copy 1 table1 to 2 table2

1 - cursor number,
2 - cursor number,
table1 - sourse table
table2 - destination table

Jaromi

[Garry]

Re: copy two table


"ja" <jaromi111@pocz ta.onet.pl> ???????/???????? ? ???????? ?????????:
news:1etlgtor6k jsh.bx223caeyi5 p$.dlg@40tude.n et...[color=blue]
> hi,
>
> How copy two table between two database?
>
> copy 1 table1 to 2 table2
>
> 1 - cursor number,
> 2 - cursor number,
> table1 - sourse table
> table2 - destination table
>
> Jaromi[/color]

Right click on table in EM -> all tasks -> export data....

[Hugo Kornelis]

Re: copy two table

On Sun, 15 Aug 2004 20:42:08 +0200, ja wrote:
[color=blue]
>hi,
>
>How copy two table between two database?
>
>copy 1 table1 to 2 table2
>
>1 - cursor number,
>2 - cursor number,
>table1 - sourse table
>table2 - destination table
>
>Jaromi[/color]

Hi Jaromi,

Probably something like this:

INSERT table2 (column1, column2, ...)
SELECT column1, column2, ...
FROM table1


Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)