It's actually a very simple query, but I don't know why it's showing me values that are actually excluded with the HAVING.
Table 1 -> Maintable
Table 2 -> Subtable (more then 1 Entry for Maintable)
SELECT
a.ID,
b.MainTable_ID,
MAX(a.ExpenditureComplete) as ExpenditureHours,
SUM(b.DurationHour) as DurationHours
FROM [Table_1] as a
Inner join
[Table_2] as b
On
a.ID = b.MainTable_ID
Where a.Inactive = 0
and b.Inactive = 0
Group by
a.ID,
b.MainTable_ID
Having MAX(a.ExpenditureComplete) <> SUM(b.DurationHour)
Try this:
Having ROUND(MAX(a.ExpenditureComplete),2) <> ROUND(SUM(b.DurationHour),2)