Sql report different database

Answered

Ramon Duunk

• October 22, 2020 07:12

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

USE TheNewDatabase
SELECT * FROM OCRD

 

Vote

0

• Official comment

  

  Caleb Das

  • October 23, 2020 15:20

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

  SELECT *

  FROM "OtherDatabaseName"."OCRD" T0

   
• 

  Ramon Duunk

  • November 26, 2020 13:34

  Hi,

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

  Ramon Duunk

  • January 05, 2021 10:39

  Did an update break this function ?

Please sign in to leave a comment.