Hi..All,


I have one problem.

Im using informix Dynamic Server v 9.4x on Windows NT System.

I have db_one,db_two databases in My instance ol_instance1

I connected to db_one database using dbaccess

How can i select the table table1 from db_two database where im in @db_one database.

i tried select * from db_two.table1

but getting syntax error.

what is the syntax for this.

Hi Maruthi,

The syntax is -

select * from db_two:table1