Consult 2 tables of 2 databases

Navigation
2

How can I consult a table in one database and another table in another database, in sql server

that is, I need to consult the company with the 2 databases

I was doing it this way but I get error

The databases are: Sk_BDDespachos and Sk_BDDespachosPruebas The tables are: Sk_Empresa and Sk_Empresa The field of tables are: Sk_Nombre_Empresa and Sk_Nombre_Empresa 

SELECT 
Sk_BDDespachos.Sk_Empresa.Sk_Nombre_Empresa,
Sk_BDDespachosPruebas.Sk_Empresa.Sk_Nombre_Empresa
FROM Sk_BDDespachos.Sk_Empresa , Sk_BDDespachosPruebas.Sk_Empresa;
    
asked by Eduard 05.01.2018 в 17:47
source

3 answers

2

You can try it this way 

    SELECT A.Sk_Nombre_Empresa, B.Sk_Nombre_Empresa
    FROM Sk_BDDespachos.DBO.Sk_Empresa A
    INNER JOIN Sk_BDDespachosPruebas.DBO.Sk_Empresa B
    ON A.Sk_Nombre_Empresa = B.Sk_Nombre_Empresa
    
answered by 05.01.2018 / 18:02
source
0
SELECT 
*
FROM Sk_BDDespachos.dbo.Sk_Empresa A 
INNER JOIN  Sk_BDDespachosPruebas.dbo.Sk_Empresa B
ON A.Sk_Empresa = B.Sk_Empresa;

Try This

    
answered by 05.01.2018 в 17:55
0

If what you need is to consult the companies of both tables you could do something like this: 

    SELECT  Sk_Nombre_Empresa
    FROM    Sk_BDDespachos.dbo.Sk_Empresa
    UNION
    SELECT  Sk_Nombre_Empresa 
    FROM    Sk_BDDespachosPruebas.dbo.Sk_Empresa

Since an inner join would show you only the companies that match and a query like the one you were doing will show you the companies of both tables related to each other. I do not really know what you expect from your query.

    
answered by 05.01.2018 в 18:22
Correctly display characters encoded in style \ xe9 [duplicated] Because when I try to run my application on the telophone it closes?