SELECT * FROM (
 SELECT
 firstView.Total,
 firstView.TotalWithGlobalDiscount,
 firstView.SaleItemsAmount,
 firstView.SaleReturnItemsAmount,


firstView.SaleItemsAmount-firstView.SaleReturnItemsAmount AS SaleAndReturnItemsAmount,
 firstView.SaleRefundItemsAmount
 FROM (
 select
 sales.Total,
 sales.TotalWithDiscount as TotalWithGlobalDiscount,

(Select ISNULL( sum(saleItems.Amount),0) from [Crs#Prod#master#PoS].[Tenant_14].SaleItems saleItems where SaleItems.OwnerId = sales.id) AS SaleItemsAmount,

(Select ISNULL( sum(SaleRefundItems.Amount),0)

from [Crs#Prod#master#PoS].[Tenant_14].SaleRefundItems SaleRefundItems
INNER JOIN [Crs#Prod#master#PoS].[Tenant_14].SaleRefunds SaleRefunds
ON SaleRefundItems.Owner_Id=SaleRefunds.Id
WHERE SaleRefunds.Sale_Id = sales.id
and SaleRefunds.State = 3
) AS SaleRefundItemsAmount,



(Select ISNULL( sum(returnItems.Amount),0) from [Crs#Prod#master#PoS].[Tenant_14].SaleReturnItems returnItems where returnItems.OwnerId = sales.id) AS SaleReturnItemsAmount

from [Crs#Prod#master#PoS].[Tenant_14].Sales sales
where sales.State  =3
) firstView

)secondView

--where secondView.Total<>secondView.SaleAndReturnItemsAmount

--where SaleRefundItemsAmount <>0