Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    11

    Unanswered: SQL Statement Error.

    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.

  2. #2
    Join Date
    Aug 2003
    Location
    India
    Posts
    262
    Hi Maruthi,

    The syntax is -

    select * from db_two:table1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •