Sql report different database Answered

Ramon Duunk

Can we make sql reports from a different database (running on the same server)
So for example :

USE TheNewDatabase
SELECT * FROM OCRD

 

Comments

3 comments

Date Votes
  • Comment author
    Caleb Das
    • Official comment

    Sure you can. Just put the database name in front of OCRD. Something like:

    SELECT *

    FROM "OtherDatabaseName"."OCRD" T0

     

  • Comment author
    Ramon Duunk

    Hi,

    Sorry for not responding, had a lot to work on. (and now even more)
    It worked perfect, thnx !

    0
  • Comment author
    Ramon Duunk

    Did an update break this function ?

    0

Please sign in to leave a comment.