Sql - update group by sum

See more:

SQL

Hi

I am trying to update a temp table with the sum of a couple of field from another table that is joined and I get the following error message with this piece of code.

"An expression of a non-Boolean type specified in a context where a condition is expected"

The code is as follows....

UPDATE #TempTable
SET TOTAL_AREA = AreaTotal,
TOTAL_AREA_VALUE = AreaTotalValue
FROM #TempTable INNER JOIN
(
SELECT SUM(tblWhereTotalsAre.AreaTotal) AS AreaTotal,
SUM(tblWhereTotalsAre.FinalValueTotal) as AreaTotalValue
FROM tblWhereTotalsAre INNER JOIN
tblHeader ON tblWhereTotalsAre.FK_ID = tblHeader.ID
WHERE tblWhereTotalsAre.ItemType = 'BUILDING'
GROUP BY tblWhereTotalsAre.FK_ID, tblHeader.Property, tblWhereTotalsAre.ItemType
)

Any idea where I am going wrong or missing.

I want to update 2 field in the temp table from a group clause in another table that has a sum.

What I have tried:

I have tried various ways but still get the error message. Tried instead of where used the having but still have a fault.