Access 2 different databases from one SQL script

[echogovadze]

Hi,

I wander if i can write INSERT statment, which selects data from table that exists in database1 into table that exists in database2? If yes - what syntax should i use?

It is so simple in TSQL... but does not work in DB2.

Thanks in advance!

Eka