50-times-faster-2.sql

SELECT
	<...>

FROM
	TTReturns AS ReturnsTable
	
		LEFT JOIN AccumulationRegister.Inventory AS TableSales
		ON 
			ReturnsTable.Item = TableSales.Item
			AND ReturnsTable.Characteristic	= TableSales.Characteristic
			AND ReturnsTable.Batch = TableSales.Batch
			AND ReturnsTable.OrderSales = TableSales.OrderSales			
			AND ReturnsTable.SalesDocument = TableSales.SalesDocument
			AND ReturnsTable.GLAccount_GL = TableSales.GLAccount_GL
			AND ReturnsTable.CostObject = TableSales.CostObject
			AND ReturnsTable.VATRate = TableSales.VATRate
			
			AND TableSales.Entity = &Entity
			AND TableSales.CorrGLAccount_GL = &EmptyAccount_GL
			AND TableSales.RecordType = VALUE(AccumulationRecordType.Expense)
			AND NOT TableSales.Return

GROUP BY
	<...>

HAVING
	(CAST(SUM(TableSales.Amount) - ReturnsTable.Amount AS NUMBER(15, 2))) <> 0