How to give alias name for a column in the given sql for the calculation to avoid null value.

Select *,
Profttarget- ( Sales - SalesCost ) as TargetRequired
From
(
Select  

Case When  sum(b.targetTotal) > 0 then  Sum(b.targetTotal)  else 0 end as Profttarget,

Case When  sum(a.salestotal) > 0 then  Sum(a.salestotal)  else 0 end as Sales,

Case When  sum(a.salescost) > 0 then  Sum(a.salescost)  else 0 end as SalesCost

From Sales A, Target B

where a.salesdate = b.salesdate ;
)t

---

Please Mark This As Answer if it solved your issue

Please Vote This As Helpful if it helps to solve your issue

Visakh

----------------------------

My Wiki User Page

My MSDN Page

My Personal Blog

My Facebook Page