Sum on Union query - syntax error - SQL Server

Question

I am trying to do sum on union query and I am getting

Syntax error: incorrect syntax near ')'

Code:

select 
    sum(rate) 
from 
    (select 
         sum(UnitsDelivered * Rate) as rate 
     from 
         Reimbursement_EBSUtilization 
     where 
         PRR_Id = 1 

     UNION ALL

     select 
         sum(Reimbursement_CDSUtilization.Rate * CDSUtilization.UnitsDelivered) as rate 
     from 
         Reimbursement_CDSUtilization
     left join 
         CDSUtilization on Reimbursement_CDSUtilization.CDSU_Id = CDSUtilization.Id
     where 
         Reimbursement_CDSUtilization.PRR_Id = 270
)--syntax error is showing here

I am sure I am missing something very small but couldn't figure out

where Reimbursement_CDSUtilization.PRR_Id = 270 ) x You need to alias your subquery with any name. — juergen d
– juergen d, Commented Apr 14, 2016 at 20:30

Giorgos Betsos · Accepted Answer · 2016-04-14 20:31:13Z

2

You need to alias the subquery:

select sum(rate) from 
(
  select sum(UnitsDelivered*Rate) as rate 
   from Reimbursement_EBSUtilization 
   where PRR_Id =1 

   UNION ALL

  select sum(Reimbursement_CDSUtilization.Rate * CDSUtilization.UnitsDelivered) as rate 
  from Reimbursement_CDSUtilization
  left join CDSUtilization on Reimbursement_CDSUtilization.CDSU_Id = CDSUtilization.Id
  where Reimbursement_CDSUtilization.PRR_Id = 270
) as t -- <-- use alias here

answered Apr 14, 2016 at 20:31

Giorgos Betsos

72.3k10 gold badges69 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sum on Union query - syntax error - SQL Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related