Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    15

    Unanswered: insert select from diferent databases

    Hi all,

    I have sybase 9.0, and I have two databases master and EFM.

    I want to move or copy one table (croma) from master to another table (croma) located in EFM, and all its contents.

    I have created a new table into EFM just like the one on master, so how do I insert all date from master into EFM one.

    thx you all.

  2. #2
    Join Date
    Jun 2004
    Posts
    15

    Solved

    well,

    after a while I found my way...
    the command is:

    insert into EFM..croma select * from croma

    thx anyway guys.

Posting Permissions

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