Home / Questions / 228784
Accepted
Huntzberger
Asked: 2020-01-11 11:17:49 +0800 CST 2020-01-11 11:17:49 +0800 CST

SQL - Total sum made of tables of different databases

  • 772

I have two databases and in each one two tables from which I need to add a field, but unified.

I did the following querybut it separates the results of each table and I need both:

Select sum(Cantidades) as Entregado 
From BD1..Facturas

Where Codigo ='00050'

Union All

Select sum(Cantidades) as Entregado 
From BD2..FacturasA

Where Codigo ='00050'

Result

Delivered

  • 5773
  • 90

Expected result

Delivered: 5863

sql-server

1 Answers

  1. Best Answer

    you must porner inside a derived table like this:

       SELECT
      SUM(t.Entregado)Entregado
   FROM
   (
      Select sum(Cantidades) as Entregado 
      From BD1..Facturas

      Where Codigo ='00050'

      Union All

      Select sum(Cantidades) as Entregado 
      From BD2..FacturasA

      Where Codigo ='00050'
   )t
    • 4