I am trying to duplicate this query

Select *
ValueA = ( Select sum(Value) from Table C Where EventId = a.EventId )
FROM TableA a

I'm having a really hard time with this

<query name="Get.All.EventData">
<![CDATA[ Select *,
EventSum = ( Select sum(Value) from Events p Where e.EventId = p.EventId )
from Employee e ]]>
</query>

But this doesn't work. Can anyone help me with this? It's really important

Thanks,
Nick

Could you put some log lines of the hibernate error?
It seems that you are using a SQL query where hibernate expects a HQL query...

yeah my sub query is incorrectly written. There's not really a log line. I just dont know how to write a line where I'm going to get a value from an individual query

This line:
ValueA = ( Select sum(Value) from Table C Where EventId = a.EventId )

Where I would query a value based on the current tables value

Table A
EventId
Name
.....

TableC
TableCId
EventId
Name
.....

I'm just confused how I would write that in an hbm query.

bump