Sql report different database

Respondida

Ramon Duunk

• 22 de octubre de 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

• Comentario oficial

  

  Caleb Das

  • 23 de octubre de 2020 15:20

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

  SELECT *

  FROM "OtherDatabaseName"."OCRD" T0

   
• 

  Ramon Duunk

  • 26 de noviembre de 2020 13:34

  Hi,

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

  Ramon Duunk

  • 5 de enero de 2021 10:39

  Did an update break this function ?

Iniciar sesión para dejar un comentario.