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"ja" <jaromi111@.poczta.onet.pl> ???/???? ? ???? ???:
news:1etlgtor6kjsh.bx223caeyi5p$.dlg@.40tude.net...
> 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
Right click on table in EM -> all tasks -> export data...|||On Sun, 15 Aug 2004 20:42:08 +0200, ja wrote:
>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
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)
